top of page
Search

No backups

  • Adam Thurgar
  • Jun 21, 2019
  • 1 min read

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).


 
 
 

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...

 
 
 
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...

 
 
 
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...

 
 
 

Comments

Couldn’t Load Comments
It looks like there was a technical problem. Try reconnecting or refreshing the page.
bottom of page