Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Brooklyn on October 24, 2014, 10:03:32 AM

Title: What are some common reasons why database restores fail?
Post by: Brooklyn on October 24, 2014, 10:03:32 AM
Hi everyone, I have a big question a little strange for you, what are some common reasons why database restores fail? I thank you please inform me :)
Title: Re: Database restores fail
Post by: Ewan on December 09, 2017, 05:21:18 PM
These are some common reasons why database restores fail:

Unable to gain exclusive use of the database.
LSNs are out of sequence so the backups cannot be restored.
Syntax error such as with the WITH MOVE command.