SQL Server数据库备份的镜像

SQL Server数据库备份的镜像

 

一个完整备份可以分开镜像，备份文件可以同时备份多份，每份都一模一样，使用场景是，比如E盘是本地备份盘，F盘是网盘，那么备份一次一个放E盘一个放F盘，不用备份两次

注意：一定要用format参数

BACKUP DATABASE [testdatabase] TO
DISK = N'C:\testdatabase1.bak'
MIRROR TO DISK = N'D:\testdatabase2.bak'
WITH FORMAT, INIT
GO


backup database  [banhao] to  disk ='D:\DBBackup\banhao1.BAK' 
MIRROR TO DISK = N'D:\DBBackup\banhao2.bak'
MIRROR TO DISK = N'D:\DBBackup\banhao3.bak'
MIRROR TO DISK = N'D:\DBBackup\banhao4.bak'
MIRROR TO DISK = N'D:\DBBackup\banhao5.bak'
WITH COMPRESSION,FORMAT

 

 

 

 

一个完整备份可以先条带化，然后再分开镜像

USE master
GO
BACKUP DATABASE [testdatabase]
TO DISK = N'C:\testdatabase1.bak',
   DISK = N'C:\testdatabase2.bak'
MIRROR 
TO DISK = N'D:\testdatabase3.bak',
   DISK = N'D:\testdatabase4.bak'
WITH FORMAT
GO    

 

 

 

 

转载自：https://www.mssqltips.com/get-free-sql-server-tips/?ref=990x30

 

本文版权归作者所有，未经作者同意不得转载。