SQL Server Database Snapshot

added by cengizh
7/25/2010 6:53:00 AM

0 Kicks, 70 Views

SQL Server database snapshot feature provides you to have a read-only copy of your current database. You can create a snapshot only on the server which is actual db located. In other words, you can’t create a snapshot on any other server than the server that host your actual database. We use snapshots for solving some reporting problem and some scenarios like that. Benefits of the snapshot is not the subject of this blog entry. If you have experience with SQL Server snapshot, did you think about this limitation? What is the design issues under this limitation?