Please backup your SQL Server Express databases

Really, please back them up. The number of non-trivial apps that now ship with a SQL Server Express backend database is increasing. And that increases the risk that you’ll end up with the one that’s corrupted or broken. Without a good backup there’s no guarantee that your precious data will be recoverable, or that what you can recover will be valid for your application. Having spent a day recovering a SQL Express database that had a couple of corrupted pages in the a datafile, I would like to offer this up to hopefully reduce the number of times I come across this.

Unfortunately SQL Server Express doesn’t come with all the nice functionality of the other SQL Server versions, so implementing backups isn’t as easy as setting up a maintenance plan (not that that’s all you need to do for good backups (See

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

No comments yet.

Leave a Reply