[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Detach Database Failed for Server
 

 

 

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

Detach Database Failed for Server.


Applies to: Microsoft SQL Server 2005 Enterprise, Microsoft SQL Server 2008.

 

Error Message.

Detach database failed for Server 'Instance Name'. (Microsoft.SqlServer.Smo)
Additional information:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

Cannot execute 'sp_updatestats' because the database is in read-only access mode.
Cannot DETACH a database snapshot. (Microsoft SQL Server, Error: 15635)

 




 

Cause.


This error came when we tried to detach a database snapshot. As SQL Server 2008 Books Online states, you cannot attach or detach database snapshots.
 

References.

Limitations on Database Snapshots
SQL Server 2008 Books Online (October 2007)


 



 

 

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