Hi All,
I would like to know how to rename a database snapshot ?
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.aspx
When I try to rename the snapshot, it is throwing error -:
Msg 902, Level 16, State 1, Line 1
To change the NAME, the database must be in state in which a checkpoint can be executed.
Thanks,
Ganesh