Oct 12, 2010 | Recovery, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, TSQL Tuesday |
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting this one out too. This month’s party is being hosted by Sankar Reddy This topic I think, maybe expect, really I know, that this topic has been covered already, I know...
Oct 12, 2010 | Recovery, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you choose for your databases will affect your restore plans in the event of failure or need to restore, the recovery model you pick will also...
Apr 4, 2010 | Backup, Recovery, SQL Server 2008 |
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log backups and a note on how to manage backup files. The next in my little series on backups is a short post on differential backups in SQL Server.What is a...
Feb 23, 2010 | Recovery, Snapshots, Storage |
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject. This post will details a few things of note about snapshots and how to create a snapshot on your database. Database snapshot provide a read-only point...
Feb 16, 2010 | Recovery, SQL Server Internals, Storage |
What is a SQL Server checkpoint? A SQL Server checkpoint is the process of writing all dirty datafile pages out to disk. A dirty page is page that has changed in memory (buffer cache) since they were read from disk or since the last checkpoint. This is done...
