Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-10-25 : 07:11:29
|
| Hi,We have mirroing setup for DR purposes.i.e.server mdr is mirroing server mQuestion:1-When I go to the mdr machine in sql server, I see the word restoring for all the databases and so when I try to do a select query from one of the databases, it says that the database is in the middle of a restore and therefore does not return data.How can I then chek to see if the data inside mdr is indeed correct ?2-in machine m, there are sql server agent jobs.in mdr machine, I do not see the sql server agents. How do I see them.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-25 : 07:49:13
|
| 1. Mirroring is basically continuous log shipping, the transaction log of the principal is constantly being restored to the mirror. As such it must remain in a restoring mode in order for the redo portion of recovery to operate. You cannot access the mirror in this state. You can configure the Database Monitoring job to maintain a log of mirroring statistics, such as unsent log, transaction delay, etc. If those stats show zero or low numbers, it means the mirror is up-to-date. There's more information here: http://msdn.microsoft.com/en-us/library/ms365809.aspx2. Which jobs are you referring to? Jobs are server-level objects and cannot be mirrored, you'd have to create them on the server manually. If these jobs perform actions on mirrored databases, they will fail on the mirror since those databases are not accessible. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-10-26 : 06:43:51
|
| Thanks |
|
|
|
|
|
|
mirroing - Restoring