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