原文:
SQL Server数据库备份的镜像
SQL Server数据库备份的镜像
一个完整备份可以分开镜像
USE master GO BACKUP DATABASE [testdatabase] TO DISK = N'C:\testdatabase1.bak' MIRROR TO DISK = N'D:\testdatabase2.bak' WITH FORMAT, INIT GO
一个完整备份可以先条带化，然后再分开镜像
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
