Note to self re: restoring backups of read-only databases

Restoring a full backup of a Read-Only database: fine.
Then restoring a diff backup of that same database: won’t work.

I’ve just wasted best part of a day chasing that one down. What’s worse is I should have remembered, as I’ve seen this before fairly recently (well, in the last year or so)…

I’ve not been well, y’know.


To add to the fun, this was using some third-party backup software, rather than SQL Server’s native backups. There was a sort of error message, but it was of the form “I’m sorry, Dave, I can’t do that”:

Cannot apply the backup on device LiteSpeed for SQL Server backup file to database '<foo>'.

Yeah. Helpful. In LiteSpeed’s defence, it’s a message generated by SQL Server.

This entry was posted in SQLServerPedia Syndication and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.