I would like to updat the my database MS SQL Server 2005 sp2 with latest update, but i'm worried about weather will affecting on my SAP application after updating databsae MS SQL Server 2005 SP2, can anybody tell me the truth what will happened on SAP Application server after updating database.
I rarely have issues with installing service packs but to be very safe, backup all of your system and users databases prior to installing the latest service pack. In particular, backup the Resource database because this contains all of the system objects. The Resource is the one that gets updated every time a service pack or a cumulative update is installed. Check out the article below on how to backup the Resource database because it isn't visible from SQL Server Management Studio.
The ideal situation is to have a high availability solution like database mirroring or even log shipping and apply the service pack on the mirror/standby first, break the synchronization, and access the database via the application to see if the system works fine after the service pack installation. If it doesn't, you still have an extra copy of your entire database server which is easier to restore as compared to restoring database backups which includes the system databases
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.