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!
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!
Comment