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. More…
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. More…
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.