How to do concurrent backups on a local and remote machine running SQL Server?
Q: I want to take backup of sql server database at my local machine and concurrently at remote machine through scheduler, please tell me how to do this?
Iain Kick says: This is new functionality for SQL Server 2005 and is only in the Enterprise edition. In order to get a detailed explanation on Mirrored backups to disk and tape, MS books online has this written up and ready to go - check the link here
Technorati Tags:
SQL Server, Microsoft books online, database backups