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
本文版权归作者所有,未经作者同意不得转载。