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 |
|
majid66
Starting Member
2 Posts |
 Posted - 2011-10-02 : 02:29:14
|
| good morning everybody,i need you help on this issue,i have 2 servers DB1 and DB2 has MSSQL Server 2005 ,Win2003 , DB1 was the primary server and the DB1 is mirrored one , we applied win patch yesterday , first DB1 then we have to restart in to make DB2 take over then visa versa but after we restarted the DB2 to make DB1 take over again but it didnt takeover its hanging , i checked the services status SQL SERVER (DB) "Starting" then i checked the Sql Server Configration Manager the state is "change pending" now i am not able to login to the Database by sql studio or to do anything , i tried to find out in all forums but to no avail , there is no clear solution.can you help me on this please , i hope this is a clear explaination for my issue.awaiting for your kind response.regards |
|
|
majid66
Starting Member
2 Posts |
Posted - 2011-10-03 : 09:09:03
|
| guys i am waiting for your reply i am really stuck :( , if you need more info just let me know.regards |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-10-03 : 10:46:43
|
| reasons for late repliesa) we hang around here when free - note we could be busy ourselves!b) your problem may be beyond the practical experience of most people herec) your problem as described may have too little info for people to take the hook and respond.if this is affecting your production seriously, don't depend on free adviced) raise a ticket with your support rep @ microsoft.com |
|
|
|
|
|
|
mirroring corrupted after applied the patch