• Adam Thurgar

No backups

Whilst doing a current system state assessment for a client of their SQL Server fleet, I found a number of production SQL Servers without any backup jobs. They have user databases, but they were not being backed up (and there was no maintenance). I found it amazing that having some database backup was not part of their SQL Server build. There are plenty of scripts out there to automate backups and maintenance.

I don't care how you do it, just backup your databases. It will make your life easier (and then at some time in the future - do a test restore).

6 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t