Assume you had dropped some records from your database but prior to dropping it you have taken a snapshot of you db, so the snapshots come handy in such scenarios. You can restore back the records from this snapshot as shown in the below figure,
I had restored the db Deepak from the snapshot Deepak_snapshot_2030 as shown below.
Command
RESTORE DATABASE Deepak FROM DATABASE_SNAPSHOT = 'Deepak_snapshot_2030'
Leave a Reply