nPath Ltd.

A wise man once told me: “The quatilty of your life is directly proportional to the quality of your backups”. I have come to respect this advice greatly. A few weeks ago my dedicated server went down. The incompitent tech support at AIT was unable to get it working again. It took them 16 days to decide the drive was toast. All data was lost.  Luckily I was somewhat prepared and had been genrating .bak files on a different server daily. But if a backup that can’t be restored it’s useless.  The wise man always followed his advice with “always do a test restore”.

This is where the error of today’s post comes into play.  I was restoring from a .bak file on my local machine to sql express when the following error appeared:

For the Search engines:
Restore failed for Server ‘.\SQLEXPRESS’
The backup set holds a backup of a database other than the existing ‘clientDB’ database.

Was my quality of life not what I once thought it was?  Hold on a minute…

I decided to check the options on the restore. Low and behold there were a few settings that made the restore work like a charm.
First I check replace database then I made sure the filenames were in the right spot. All was right with the world. Inner peace restored.