August 20, 2007 at 2:16 am
I'm using SQL Server 2005 Enterprise Edition on Win2K3 Advanced Server, if I choose to use the "High Performance" option for SQL Mirroring can I take a database snapshot of the mirror database for reporting purposes?
I've read somewhere that the I have to use "High Availability" mirroring to take the snapshot, but I can't find where I read this. Is this true?
Thanks in advance.
www.sqlAssociates.co.uk
August 20, 2007 at 4:05 am
I've found the link:
http://msdn2.microsoft.com/en-us/library/ms175511.aspx
The last sentance in the first paragraph states:
"To create a database snapshot on a mirror database, the database must be in the synchronized mirroring state."
Does this mean that to take a snapshot of a mirrored database I must be using the "High Availability" (synchronous) SQL Mirroring option rather than the "High Performance" option?
Thanks in advance.
www.sqlAssociates.co.uk
August 20, 2007 at 5:13 am
Hi
i dont think you need to use the "High Availability" (synchronous) SQL Mirroring option, though iam not sure.
Synchronized state means that mirror server is in nearly the same state (not fully) as the principal server.
"Keep Trying"
August 20, 2007 at 5:33 am
Hi,
The sentance does state "the database must be in the synchronized mirroring state.", the bit I am interested in is the "in the synchronized mirroring state". I thought there were just two mirroring states "synchronous" (High Availability/High Safety) and "asynchronous" (High Performance)?
Thanks.
www.sqlAssociates.co.uk
August 20, 2007 at 7:13 am
Chris, I dont think so.....you can take database snapshot of the mirror db if you have enterprise edition of sql 2005 installed in mirror server........
[font="Verdana"]- Deepak[/font]
August 20, 2007 at 8:27 am
Chris, there are 2 states, but 3 modes. A snapshot should move.
August 21, 2007 at 12:55 am
Thanks guys for your help, much appreciated.
www.sqlAssociates.co.uk
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply