SQL2005 Snapshot 語法

<br /><br />--只能在SQL2005本地執行<br />--Snapshot<br />IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = 'DBNAME') DROP DATABASE [DBNAME]<br />GO<br />CREATE DATABASE DBNAME ON<br />( NAME = DBNAME, FILENAME = 'D:\Backup\Snapshot\DBNAME.SS' )<br />AS SNAPSHOT OF DBNAME;<br />GO<br /><br />--Restore<br />use master<br />GO<br />RESTORE DATABASE DBNAME<br />FROM DATABASE_SNAPSHOT = 'SnapshotName'<br />GO<br /><br />