SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 mirroring corrupted after applied the patch		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

majid66
Starting Member

United Arab Emirates
2 Posts
Posted - 10/02/2011 :  02:29:14  Show Profile  Reply with Quote
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

United Arab Emirates
2 Posts
Posted - 10/03/2011 :  09:09:03  Show Profile  Reply with Quote
guys i am waiting for your reply i am really stuck :( , if you need more info just let me know.

regards
Go to Top of Page

AndrewMurphy
Flowing Fount of Yak Knowledge

Ireland
2915 Posts
Posted - 10/03/2011 :  10:46:43  Show Profile  Reply with Quote
reasons for late replies

a) we hang around here when free - note we could be busy ourselves!
b) your problem may be beyond the practical experience of most people here
c) 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 advice
d) raise a ticket with your support rep @ microsoft.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000