SQL-Articles
On Premise and Cloud Database Knowledge Base

Restoring from Database Snapshot

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'

restore_from_database_snapshot

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*