This article shows several ways you can restore an SQL Server database backup. In particular, we will consider how to restore a database
Continue reading How to restore an SQL Server database from backup
Category Archives: Database restoration
Hot Questions Related to SQL Server Backup
We have noticed that users sometimes have different questions while working with SQL Server which on the one hand are easy and simple and on the other, they try to avoid asking them. In this post, we are going to answer some of the most common questions. Continue reading Hot Questions Related to SQL Server Backup
Unable to Create Restore Plan Due to Break in the LSN Chain
Sometimes when you restore your database backup you can get an “Unable to Create Restore Plan Due to Break in the LSN Chain” error. Let’s see how to deal with it. Continue reading Unable to Create Restore Plan Due to Break in the LSN Chain
RESTORE VERIFYONLY and CHECKSUM options
For any SQL Server DBA who’s been in the field for a long time, you know that the exercise of restoring backups taken in SQL Server 2000 (and even SQL Server 2005 without using the CHECKSUM option) was many times a sweat-filled lottery. You usually gambled and/ or prayed to your respective deity that your backups would actually work. Why? Because you knew that restore failures were all too common. Despite SQL Server’s assurance that all was well because you had already verified your backups with the RESTORE VERIFYONLY option. So why was this the case? Why did restore operations fail so frequently? Let’s delve a bit more into the innards of the RESTORE VERIFYONLY and CHECKSUM options to find out.