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 |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2010-01-07 : 01:28:37
|
| Hi, I am working on a database which is mirrored ..so, the mirroed database in resotring ..we can not open it (+) in sql server management studio...now i want to check that what stored procedure i created in the principal database it is there in the mirror database also..? How can i check this..? I created one login in principal database ...same i want to create in mirror database also..but in sql server management studio i can not select mirror database name as a default database ...how to do this ..? any idea .... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-07 : 11:44:01
|
| You can't check the mirror database to see if a stored procedure got copied over there. Use database mirroring monitor to verify if they are in sync or not.You can not select the default database as the mirror one. Use master instead. Or break down mirroring, set the default databse, and then set it up again. Alternatively you could failover to the mirror server, set the default database, and then failback.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
Database mirroring