Piecemeal Database Restore
Produced: 16/10/2016 16:16:00
This is a direct follow up from my last post about filegroups because without those we wouldn’t be able to perform what is called a Piecemeal database restore and, trust me, this is something you want to know how to do.

Shrink Log Without Breaking a Backup Chain
Produced: 24/01/2016 20:39:00
This is something I see asked all over the internet and it’s also something for which there are a LOT of incorrect responses, dodgy solutions, and poor advice (including on the MSDN website). Therefore as I’ve had to resize a few transaction logs recently I thought I’d share the code and process I’ve used.

Full Backup Does Not Truncate Log
Produced: 12/10/2014 08:30:00
This is a massive misconception that has been going around for a long while and it needs to be wiped out.

Basically this is the belief that if you have a database in FULL recovery mode and take a full backup, then it truncates the log.

This is NOT true.

SQL Server 2008 backup compression... instance level or not?
Produced: 20/10/2013 16:34:00
Initially I would have said to set this within sp_configure because although it is CPU intensive, I have always found that the cost is more than covered by the level of reward.

However, I have recently discovered something which causes a little more thought before simply applying this at the instance level and not individually to backup scripts or maintenance plans.

Copy-Only Backup
Produced: 18/08/2013 09:50:00
This is a crucial addition to SQL Server which is invaluable at times. It basically takes a snapshot of the database rather than an actual backup. Therefore it can be used to restore a database and to provide a copy, but crucially it does not break the backup chain.

What is a backup chain? Well, when you have a database in Full Recovery mode you need a constant chain of backups in order to have the ability to restore the database correctly.

Backup a Database Using TSQL
Produced: 11/08/2013 20:17:00
This is actually the cleanest and quickest way to produce a backup as it is a one line command in the form of:

BACKUP DATABASE <database_name> TO DISK = <backup_device>

Backup a Database Using SQL Server Management Studio
Produced: 04/08/2013 20:12:00
Making backups using the GUI is a little longer than when using T-SQL (here), but they do provide a much easier way to see and customise your backup options.

Creating a Simple Backup Maintenance Plan
Produced: 28/07/2013 19:23:00
It is possible and perfectly acceptable to put T-SQL commands into a scheduled task in order to create a full backup plan, but a Maintenance Plan is Microsoft’s way of allowing you the power of the GUI backup with the convenience of a scheduled task so that you don’t have to code your own.

Backup Types
Produced: 30/06/2013 09:14:00
There are 3 backup types within SQL Server… Full, Differential, and Transactional.

The reason for there being 3 types are not immediately obvious but understanding them is key to having a good backup strategy within your system. These are also relevant to the Recovery Mode of your databases.