Start a Conversation

Unsolved

This post is more than 5 years old

857

December 22nd, 2016 15:00

Can we take SQL server backups to two data Domain servers, Like we do with Native SQL server , two backup files for the same database in different location

Can we take SQL server backups to two data Domain servers, Like we do with Native SQL server , two backup files for the same database in different location

2 Intern

 • 

14.3K Posts

December 24th, 2016 13:00

You can either make two backups to two different locations where each location is one DD or to one location (DD) and have it replicated by DD onto second one.

2 Posts

December 27th, 2016 07:00

Thanks ble, should i just use "MIRROR TO" and mention the second DD location. id it possible to provide me with an example . Thanks in Advance

2 Intern

 • 

14.3K Posts

January 4th, 2017 09:00

Yes, you could use mirror to disk statement and supply secondary location if you wish to have SQL controlled mirror or have mtree replication on DD to have mirror on DD level.  I can't give you example as I use backup application to do the same, but you can find some examples of mirror command around the net so it should not be a problem.

No Events found!

Top