How to do a mirrored backup of a database in sql server to a file location

Karthikanbarasan
Posted by Karthikanbarasan under Sql Server category on | Points: 40 | Views : 2003
BACKUP DATABASE Sampledb
TO DISK='D:\SampledbMirror1.bak'
MIRROR TO DISK='E:\SampledbMirror2.bak'
WITH FORMAT, DESCRIPTION = 'Mirrored Backup in Sql'

Comments or Responses

Login to post response