Post reply

Which databases does the service pack change?

  • July 8, 2003 at 1:56 am

    #64644

    I am planning to do an sp_detach, copy and then sp_attach in order to move a database from one server to a new one. However the server I am copying it from is only SQL 7 SP2 and the new one I have installed SP4. We only have a very small timeframe to take down the server so I am hoping to avoid having to take down the server to patch it to SP4. So my question is do the service packs change anything in databases other than the standard ones (master, msdb etc)so that I can just copy it accross.

    Any advice would be much appreciated

    Paul

  • July 8, 2003 at 6:19 am

    #464460

    I think service pack touchs only system databases. You need to watch the performance after the movement and maybe have to update database statistics and perform optimization to your database.

  • July 8, 2003 at 7:30 am

    #464495

    Thanks for your advice.

    Paul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply