Sychronised Mirrored SQL servers/databases

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

original PM replied

18 July 2011, 09:26
useful info all.

Many thanks
Leave a comment:
Spacecadet replied

18 July 2011, 09:05
Originally posted by fullyautomatix View Post

It is true, there is no easy way to dynamically query a mirror. I think the mirror works in way that every query executed against the main database is executed against the mirror. So allowing a query against the mirror might break the logic of maintaining data integrity. What should happen if you execute a query which modifies the data in the mirror ?

i.e it breaks ACID compliance
Leave a comment:
fullyautomatix replied

18 July 2011, 08:54
It is true, there is no easy way to dynamically query a mirror. I think the mirror works in way that every query executed against the main database is executed against the mirror. So allowing a query against the mirror might break the logic of maintaining data integrity. What should happen if you execute a query which modifies the data in the mirror ?
Leave a comment:
rsingh replied

16 July 2011, 18:29
Create a snapshot against the mirror and query the snapshot.
Leave a comment:
PAH replied

16 July 2011, 08:03
Surely each database is backed up on their respective server as a measure against individual server problems.

Get a copy of both backups (preferably taken as close together as possible), restore to a test server, and do a full database compare including data to ensure they are in sync.

Allow a slight discrepancy for when the backups were done and any data pending syncing at that point.

If the above is not possible then I'd guess your setup is not 'optimal'.
Leave a comment:
eek replied

15 July 2011, 19:34
Depending on the mode you are using you can't do much.

Mirroring States explains the mirroring states.

Do you have witness servers monitoring the systems?
Leave a comment:
original PM started a topic Sychronised Mirrored SQL servers/databases

15 July 2011, 16:59
Sychronised Mirrored SQL servers/databases

Hoping I can get some help from you clever techy guys here

I have a sql server (2008) holding a number of databases - and as a dr/backup solution it is mirrored and sychronized -- which is great.

However being the perfectionist I am I want to be able to check the mirror peridoically and ensure that the data is indeed kept up to date and therefore will be available if needed.

However our techy guys tell me I cannot see the data on the other server - can anyone offer any advice on this situation?

I do not want to call them a bunch of lying toads but I cannot see that MS would offer a solution of this type which does not allow a check to make sure it is working.

Otherwise the first time you find out it is not working is when you try to use it -- which is a tad late I would imagine.

Cheers!
Tags: None