Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Resets the status of a suspect database.


sp_resetstatus [ @DBName = ] 'database'


[@DBName =] 'database'

Is the name of the database to reset. database is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)


sp_resetstatus turns off the suspect flag on a database. This procedure updates the mode and status columns of the named database in sysdatabases. The SQL Server error log should be consulted and all problems resolved before running this procedure. Stop and restart SQL Server after executing sp_resetstatus.

A database can become suspect for several reasons. Possible causes include denial of access to a database resource by the operating system, and the unavailability or corruption of one or more database files.


Only members of the sysadmin fixed server role can execute sp_resetstatus.


This example resets the status of the PUBS database.

EXEC sp_resetstatus 'PUBS'

See Also

Insufficient Disk Space

Resetting the Suspect Status

Troubleshooting Recovery

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft