Wednesday , May 29 2024

Mirror Backup On SQL Server(Multiple Copies of a Backup)


You may want to import a database backup on multiple disks as multiple copies. For example, suppose you have a storage that you use for backup and you regularly receive your backups here.

But let’s assume that you need to backup both storage and an external disk for a while. You can copy your backups on the storage to this external drive. Or you can take your backups in multiple copies and forward one to your default storage and the other to the external drive. To do this, you need to use the mirror command. You can perform as follows.

In the following script, the backup of the AdventureWorks2014 database is taken into both “C:\Backup\” and “D:\Backup\” paths.  The backups in these two paths are exactly the same.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *