Upgrading database dumps

If you use scripts to perform database loads using the load database and load transaction commands, the scripts will fail unless you include the online database command at the end of your load sequence. You should also remove the following sp_dboption options from your scripts: no chkpt on recovery, dbo use only, and read only. These options are no longer needed with release 11.0, as load database sets the database status to offline, thus making it inaccessible by users.

For more information on upgrading database dumps, see Chapter 21, “Backing Up and Restoring User Databases,” in the System Administration Guide and the load database and dump database commands in the Reference Manual.