idera
2 Bronze

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

0 Kudos
3 Replies
ble1
7 Thorium

Re: 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

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.

0 Kudos
idera
2 Bronze

Re: 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

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

0 Kudos
ble1
7 Thorium

Re: 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

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.