How to rename the database snapshot | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to rename the database snapshot

Hi All,I would like to know how to rename a database snapshot ? Please help.If you could take a look at the following link, I am trying to achieve the (1) solution.http://blogs.msdn.com/b/sqlcat/archive/2008/08/05/microsoft-sql-server-database-snapshots-and-synonyms.aspxWhen I try to rename the snapshot, it is throwing error -:Msg 902, Level 16, State 1, Line 1To change the NAME, the database must be in state in which a checkpoint can be executed.Thanks,Ganesh
See this connect item: http://connect.microsoft.com/SQLServer/feedback/details/621879/unable-to-rename-database-snapshot for information.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |