Post reply

Applying SP4 on a running database?

  • February 19, 2007 at 1:52 am

    #90951

    I have a sql server 2000, with sp3 installed.

    Can i apply sp4 while users are connected and working?

  • February 19, 2007 at 3:03 am

    #690408

    Better to do this in offline mode.

  • February 19, 2007 at 4:11 am

    #690410

    Ok, thank you, I will wait..

  • February 19, 2007 at 4:48 am

    #690414

    YOu can start applyingthe SP4 when the database is being accessed, but remember that the SQL server will be restarted multiple times by the SP4 setup programm and hence the users will be disconnected. Hence applying any SP should be done with the planned downtime . Also remember to take Backups of Master, msdb and model DBs

  • February 19, 2007 at 5:22 am

    #690419

    I will make backups of those db's. But the chances are small that it will cause any errors, right?

  • February 20, 2007 at 6:05 am

    #690624

    You MUST apply Service packs with no user connections. The SP apply will start with users in the db but eventually it will need exclusive control of SQL Server and if there are users in it the Service Pack apply will fail. Before you begin applying SP backup master, model,msdb and user dbs !  Changes are only made to master, model, msdb but if you have a catastropic problem and Microsoft has to get involved to help you sometimes the answer is reinstall SQL Server. Also, as in the ReadMe Microsoft states stop all unneeded services on the server while applying a SP. IIS, backup software, server monitoring software, etc.....

  • February 20, 2007 at 6:14 am

    #690629

    Thanks!

    I did the update, and it went smooth

    Thank you for your help!

  • February 13, 2023 at 5:04 pm

    This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

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