Tag: database snapshot

  • How Database Snapshot Works

    Its essential that a DBA understands what happens when a snapshot is created. The following process happens, Database snapshots operate at the data-page level. Before a page of the source database is modified for the first time, the original page is copied from the source database to the snapshot. This process is called a copy-on-write […]

  • Database Snapshot

    What is a Database Snapshot? * The Database Snapshot is a new feature that is available in Enterprise edition of SQL Server 2005. * It provides a read-only, static view of a database. * Multiple snapshots can exist for a single database on the same server instance as the database.

  • Pros and Cons of Database Snapshot

    The following are the advantages and disadvantages of database snapshot.

  • Creating Database Snapshot

    One of the exasperating things while creating a snapshot is that you cannot use SQL Server Management Studio (SSMS) instead you need to make use of T-SQL. I am creating a snapshot of the database Deepak as follows,

  • 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,.