September 7, 2010 at 4:48 pm
Hi,
We want to go for SQL Server 2008 Standard edition and want to know database mirroring limitations in standard edition of SQL Server 2008
Thansk
September 7, 2010 at 5:21 pm
You can check for some info here ...>>> http://tinyurl.com/2u73lwf
September 7, 2010 at 10:19 pm
Thank you,
We have the below three different modes for Database Mirroring:
1. High Performance (asynchronous) -- Commit changes at the principle and then transfer them to mirror
2. High safety without automatic failover (synchronous) -- Always commit changes at both the principle and the mirror
3. High safety with automatic failover (synchronous) -- Requires a witness server instance. Commit the changes at both principle and the mirror if both are available. The witness controls the automatic failover to the mirror if the principle becomes unavailable
In above 3, High Performance (asynchronous) mode is NOT available in Standard.. Other than this what are the other limitations?
Does the other 2 modes are fully supported in Standard Edition?
Does automatic failover supported in Standard edition?
Thanks
September 8, 2010 at 3:54 am
I use 2 on a standard edition SQL2008. IIRC 3 is also supported, only High Performance isn't.
One thing to note is that Standard doesn't support database snapshots, so you can't create a snapshot of your mirror for querying purposes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply