3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 5: Upgrade Production SQL Servers 95

•Logins

•DTS packages

Before starting the upgrade, verify that you can restore the backup onto

your test machine.

4. Notify Users of Upgrade Start

For a planned upgrade, users should anticipate application down time

and prepare for it. However, notifying users that the upgrade is starting

shows that the process is under control and that the plan is being

executed properly.

5. Apply the Upgrade

Upgrade the production server as described later in this chapter. Upgrade

procedures are provided for SQL instance upgrades and general machine

upgrades such as operating system service packs.

6. Confirm the Upgrade

If the upgrade was successful, check the SQL error logs and event logs for

any errors. Also check basic database access by connecting with the

Query Analyzer and querying one of the databases.

If the upgrade failed, return the machine to the exact machine state before

the upgrade. To do this, perform a restore using your backup files.

7. Notify Users of Upgrade Completion

When the upgrade is complete, notify users that they can resume their

regular database activities.

8. Back Up the Machine State

Back up the new machine state and create a base line.