Thursday, July 13, 2017

Database Snapshots

use master

Create database Community_Assist_Snapshot
on 
(name='Community_Assist', 
Filename='C:\Program Files\Microsoft SQL Server\MSSQL12.ITC224_6\MSSQL\DATA\Community_Assist_snapshot.ds')
As
snapshot of Community_Assist

Use Community_Assist_Snapshot

Select * from Person

Use Community_Assist
update person
Set PersonFirstName ='jason'
where personkey=1

use Master
Restore database Community_Assist 
from Database_snapshot = 'Community_Assist_Snapshot'

No comments:

Post a Comment