SQL Server Performance

How to rename the database snapshot

Discussion in 'SQL Server 2005 General DBA Questions' started by gb2000, Nov 13, 2010.

  1. gb2000 New Member

    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
  2. satya Moderator

Share This Page