Categories
DBA

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

By Deepak

Microsoft Most Valuable Professional (MVP) award-winning Database Designer with 5 years of experience in designing, administering, developing & performance tuning relational databases and data warehouse.

I possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) which has around 50 members.

I am passionate about solving business problems using my technical skills and hence I am interested in the field of Technology Consulting in Information Management.

Leave a Reply

Leave a Reply

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

*