• Adam Thurgar

Restore checklist


What do you check after you have successfully restored a database.

Here is my quick checklist:

- database is online

- you can see the database objects

- you can query a table or two

- database used space is about what you expected

- check file locations to make sure they are correct

- check database owner

- check compatibility level

- check recovery model

- check database file sizes and autogrowth

- Drop all old auto created statistics

If all of these are fine then if I have time I would:

- Run a full checkdb on the database

- Run full maintenance on the database (index optimize, update statistics)

- Backup the database


7 views

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