Using SQL Server 2005 Database Snapshots

In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.

Duration:	7 mins 31 secs
Skill Level:	200
Rating:	4.22 out of 5
Publish Date:	September 30, 2006

Using SQL Server 2005 Database Snapshots

Watch Video Now Watch it later!

12345
1=Poor, 3=Good, 5=Excellent

About the Author

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

References

Code example

Using Snapshots in SSIS

Comments

suryavithala on 1/2/2009

Excellent

Purushtham Kumar katakam on 6/1/2009

Good concept.

RJ Troudt on 7/13/2009

Gunna make a snapshot right now!

Monty on 10/8/2009

Excellent introduction to Snapshots.

Aamir Ali Ansari on 12/19/2009

Clarified my concepts of snapshot.

Must Be Logged In