Working with SQL Server sometimes you have to restore your database and sooner or later during the restoration process you can receive the following error message:
Msg 3117, Level 16, State 1, Line 1 The log or differential backup cannot be restored because no files are ready to roll forward. Msg 3013, Level 16, State 1, Line 1 RESTORE LOG is terminating abnormally.
In this article, we are going to discuss how to solve the error which can occur during the restoration of a differential backup. Here is the error message:
Msg 3136, Level 16, State 1, Line 1 This differential backup cannot be restored because the database has not been restored to the correct earlier state. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
You can make SQL Server database backups with the help of T-SQL Commands or with the help of SSMS and then move them to OneDrive. But how much time it will take you to do it? Use SqlBak and spend 5 minutes to create a backup job which will make schedule backups and send them to OneDrive. Continue reading How to Backup SQL Server to OneDrive
Nowadays Google provides quite cheap storage where you can store your SQL Server database backups. But it isn’t easy to make SQL Server backups directly to Google Drive on a regular basis using T-SQL Commands. However, it is really easy if you are using SqlBak. Continue reading How to Backup SQL Server to Google Drive
It goes without saying that as a DBA one of your most important tasks is to schedule and ensure regular backups of your databases. But by ‘databases’ here we usually mean your user-created databases. But SQL Server also automatically creates and maintains a number of system databases. So should you also back these up? Well, the answer isn’t a simple yes or no … Continue reading Should You Back Up Your System Databases?
As a DBA, you have almost certainly taken a backup from one computer/ server for the purposes of restoration on another computer. It’s a somewhat tedious and manual process, but most of us are sort of resigned to it and accept it simply as a necessary evil of the DBA role. I mean, it’s not like you can automate the entire process, right? Well, hold that thought … Continue reading Automated Database Backup-and-Restore for SQL Server