Hi Justin, We moved our SQL backups away from NB agent backups to SQL server backups and then using NB to pick up the flat files. The reason for this were the numerous issues we were getting with backups and, primarily, restores.
When speccing our SQL 2008 environment, Microsoft advised against using backup agents and to use SQL Server to create flat file backups, we haven't seen any issues with our mirrored (and clustered) DBs at this point of time. Regards, Brendan Clover Information Technologist Systems Infrastructure University of South Australia Phone: +61 8 830 23641 Fax: +61 8 830 25800 Log your own service calls here: http://www.unisa.edu.au/helpdesk AskIT documentation and FAQs: http://www.unisa.edu.au/askit ------------------------------------------------------------------------------- This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorised. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately -----Original Message----- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Justin Piszcz Sent: Friday, 16 July 2010 6:14 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] Microsoft SQL Backups on MSSQL Shared Application Cluster? Hi, Has anyone here backed up MSSQL databases that are mirrored within a cluster? I have several clients who run a sole MSSQL DB that backup without issue in 6.5.x environments. However, when the DBs are mirrored, if there are processes cleaning/migrating data between a mirrored pair, the backup fails. What is the proper method to backup MSSQL DBs in this instance? Justin. _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu