Hi,
Thank you for the response.
Justin.
On Mon, 19 Jul 2010, Brendan Clover wrote:
> 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
|
