[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Transient database snapshot has been marked suspect

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Transient database snapshot has been marked suspect.


Applies to: Microsoft SQL Server 2008 R2 or later.
 

Problem Description.
 

The following error appeared while running a routinary DBCC CHECKDB on a database:


Msg 5269, Level 16, State 1, Line 1
Check terminated. The transient database snapshot for database 'DatabaseName' (database ID 7) has been marked suspect due to an IO operation failure. Refer to the SQL Server error log for details.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.


Cause.


This error appeared because the database was located on a drive running out of space due to unexpected grow of a table on another database.


Solution.


Once I recovered lost space on the drive I was able to run successfully the DBCC CHECKDB command. 


 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.