Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Step by Step process to follow before and after applying patches on sqlserver Expand / Collapse
Author
Message
Posted Thursday, January 6, 2011 9:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:22 PM
Points: 3, Visits: 71
Hi

Can anyone briefly tell me the step by step process to follow before and after applying the patches on sqlserver.

Thanks in advance
Post #1044130
Posted Thursday, January 6, 2011 10:23 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
You can make use of the steps mentioned in these articles.

http://www.mssqltips.com/tip.asp?tip=1764

http://support.microsoft.com/kb/958734


Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1044133
Posted Thursday, January 6, 2011 10:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:22 PM
Points: 3, Visits: 71
Thanks for your reply and do we need to make user database into single user mode to avoid access of any other user?
Post #1044143
Posted Friday, January 7, 2011 12:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
You need not change any settings on the instance. The Service Pack installer will take care of stopping and starting the instance.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1044200
Posted Friday, January 7, 2011 4:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:22 PM
Points: 3, Visits: 71
Thanks you
Post #1044288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse