I have a requirement to rename a database snapshot on SQL Server 2005 SP2. I am getting the following error -:
EXEC sp_renamedb 'ARSystemReporting', 'ARSystemReportingNew'
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.
Main OLTP system database mirrored to secondary. On the secondary created a database snapshot ARSystemRemedy applications are accessing the database. There is a situation to create another snapshot with ARSystemRemedy_New and drop the ARSystemRemedy and later rename the ARSystemRemedy_New to ARSystem.
I am doing this to reduce the downtime during the database snapshot creation time.