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: Tuesday, August 25, 2015 10:05 AM
Points: 4, Visits: 104
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: 2 days ago @ 12:48 AM
Points: 1,618, Visits: 20,989
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: Tuesday, August 25, 2015 10:05 AM
Points: 4, Visits: 104
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: 2 days ago @ 12:48 AM
Points: 1,618, Visits: 20,989
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: Tuesday, August 25, 2015 10:05 AM
Points: 4, Visits: 104
Thanks you
Post #1044288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse