To verify that a database has upgraded successfully, you can
check any database’s upgrade status using the online
database command. If any upgrade is required for a database,
this command performs it. You may also use a procedure such as this
to check all databases at a given installation:
declare @dbname varchar(255)
select @dbname = min(name)
from master..sysdatabases
while @dbname is not null
begin
online database @dbname
select @dbname = min(name)
from master..sysdatabases
where name > @dbname
end
Note: There are certain upgrade failures from which the server
cannot recover. For example, attempts to upgrade system tables to
version 15.0 format are quite sensitive to failures at certain points
during the required changes. If you encounter such a failure, restore
the failed database from backup. To prevent the upgrade from failing
again, correct the problem that caused the original failure
before
issuing
the online database command for that database.
These catastrophic failures are nearly always caused by running
out of resources, as described above, which then causes a failure
to undo the aborted transaction.