Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nhuanlieu
Starting Member
27 Posts |
 Posted - 2009-05-28 : 16:22:55
|
| Using Microsoft SQL Server 2005 - 9.00.3042.00 (Build 3790: Service Pack 2) Was wondering if I can I do a SQL "mirror" db backup (FULL, DIFFERENTIAL, OR Trans_Log) to different locations same time. For example, can I write 2 sets of the SAME transaction logs backup files to File_Server_A & File_Server_B without messing up the just- in-time restore process. PS - If so, we have the options to use Litespeed or native 2005 SQL backup software.Thanks in advance. |
|
|
nhuanlieu
Starting Member
27 Posts |
Posted - 2009-05-28 : 16:51:50
|
| May have answered my our question. The answer is yes with "MIRROR TO" keyword:BACKUP DATABASE MyDatabase TO DISK='E:\MyDatabase.bak' MIRROR TO DISK='F:\MyDatabase.bak' |
 |
|
|
|
|
|
do a SQL "mirror" db backup ?