How to rename the database snapshot | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
How to rename the database snapshotHi 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.