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-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Justin
Piszcz
Sent: Friday, 16 July 2010 6:14 PM
To: veritas-bu AT mailman.eng.auburn DOT 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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|