Check logical and physical database consistency by running the following commands in each database. Use isql to log in to the server, and run:
dbcc checkalloc
dbcc checkalloc [(database_name [, fix | nofix] )]
dbcc checkdb
dbcc checkdb [{database_name [, skip_ncindex]) ]
dbcc checkcatalog
dbcc checkcatalog [(database_name)]
For a description of the dbcc functions, see the System Administration Guide.
If you encounter any errors while running these commands, resolve them before continuing the upgrade. For help with resolving errors, see the Troubleshooting and Error Messages Guide.
If you are upgrading from Adaptive Server 11.5.1 or later, and you have set up your system to run dbcc checkstorage, you can use that command instead of the other dbcc commands to check database consistency. For details on using dbcc checkstorage, see the System Administration Guide.
If a database is marked “suspect,” drop that database with the dbcc dbrepair (database_name, dropdb) command.
