Categories
DBA

How to Delete a Database Snapshot

You cannot drop a database before dropping the snapshot created for the database. Now I have dropped the snapshot Deepak_snapshot_2030 created for the db Deepak. Refer the figure below illustrating how to drop a database snapshot,.

Command

DROP DATABASE Deepak_snapshot_2030

delete_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 *

*