Results 1 to 3 of 3

Thread: Applying SP3

  1. #1
    Join Date
    Apr 2004
    Posts
    79

    Unanswered: Applying SP3

    Hi

    I am basically a sybase guy but unfortunately I need to patch a SQL server with SP3. This is the first time I will be doing that. So I am not sure that after applying SP3, if I would need to rebuild all databases again.

    Could anybody tell me what and where is the impact when we install SP3..??

    I would appreciate any kinda help.

    Rgds

    Wilson

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Make a backup of any production database (including master and msdb) before you apply sp3 (just to be paranoid). Apply the service pack, reboot NT, and go merrily on your way. No rebuilding or other "care and feeding" needed unless something goes dreadfully wrong during the application of the service pack.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    just to be paranoid

    I thought that was part of the job....

    Oh, and someone once told me...in response to

    "Do you think everyones out to get you? Are you Paranoid?"

    "You're only Paranoid if you're wrong"

    So what's the downside?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •