Check out our new blog post on Internals of Database Snapshot Part-2. This blog is the joint effort of Suhas and me.   Internals of Database Snapshot – Part 2: Snapshot and the Buffer Pool

  Check out our new blog post on Internals of Database Snapshot. This blog is the joint effort of Suhas and me. http://blogs.msdn.com/b/suhde/archive/2011/07/31/internals-of-database-snapshot.aspx  

  It is always on ease having a backup and recovery strategies in place but few times it also important to recover a database to appoint which doesn’t require a full database restore or in shot no hard efforts. While working with one of my previous organization I was asked to do something which actually […]

Database snapshot feature is available in MS-SQLServer2005 and SQLServer2008.It is supported by all recovery models of SQL Server 2005 and SQL Server 2008. A Database snapshot is read-only, static view of a database (the source database). A Database snapshot captures the data and committed transitions of the OLTP Database. No uncommitted transactions are recorded in database […]