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.


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?


Has anyone here backed up MSSQL databases that are mirrored within a 

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?

Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu

Reply via email to