asked on

SQL Server 2008 R2 Database Mirroring

We are considering using Mirroring for a server that will be used for reporting. My first question is if our Production Server is called A and the new reporting server will be called B. Will the A be the principle and B be the Mirror? I want to use high-performance mode. I want users to be able to select from(read only) the mirrored server. Can you tell me if this will work or do I have to do some sort of snapshot or what?.. We have a replicated server but since the vendor refuses to add PK's to some tables we can not replicate those tables which is why we are looking at Mirroring for our SQL Server 2008 R2 servers.

didnthaveaname

You would need to make a snapshot of the mirrored database on the mirror server (which would indeed be B and A would be the principal server ). Have a read of this article, it should answer your questions (and it has some nice example cases too):

http://msdn.microsoft.com/en-us/library/ms175511.aspx

Ramesh Babu Vavilla

NO in Mirroring as your mirrored database is in No recovery mode, mirrored datbase are not accesible to users,

implement Log shipping and set the standy databases in standyby mode so that you can run select query on the database

cheryl9063

ASKER

hmm..In log shipping you would have to kick all users out to apply the logs correct? I'm hearing from several sources that mirroring and snapshot is the way to go. Have you tried this sqlservr and it not worked for you?

Ramesh Babu Vavilla

how about snapshot replication

ASKER CERTIFIED SOLUTION

didnthaveaname

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer