วันพุธที่ 21 เมษายน พ.ศ. 2553

Database Snapshot (Transact-SQL)

******* Create Database Snapshot (T-SQL)*******

CREATE DATABASE AdventureWorks_dbss1800 ON
( NAME = AdventureWorks_Data, FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\AdventureWorks_data_1800.ss' )
AS SNAPSHOT OF AdventureWorks;
GO

******* View Database Snapshot (T-SQL) *******

slect * from sys.databases

******* Revert Database Snapshot (T-SQL) *******

USE master;
-- Reverting AdventureWorks to AdventureWorks_dbss1800
RESTORE DATABASE AdventureWorks from
DATABASE_SNAPSHOT = 'AdventureWorks_dbss1800';
GO

******* Drop Database Snapshot (T-SQL) *******

DROP DATABASE SalesSnapshot0600

ไม่มีความคิดเห็น:

แสดงความคิดเห็น