Welcome to MSDN Blogs Sign in | Join | Help

Benjamin Wright-Jones

SQL Server Lessons Learned and Notes from the Field (Microsoft Consultancy Services, UK)

News

  • This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com Locations of visitors to this page
Why can't I backup the mirror database?

I'm currently working with a customer who had a requirement to backup the mirror database.  You may wonder why they want to do this - there are a number of reasons which I won't go into right now.  The simple answer is that it is not possible to backup the mirror database as it is in a recovering state.  It is not even possible to use any SAN-based solution to take a clone/snap due to the same reasons.  What I mean by this is that whilst it may be possible, it will not be supported and the database consistency cannot be guaranteed.

Maybe a feature request for Katmai+1?

Posted: Tuesday, November 27, 2007 10:07 PM by benjones
Anonymous comments are disabled
Page view tracker