Category Archives: Uncategorized

The log or differential backup cannot be restored because no files are ready to rollforward

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.

Continue reading The log or differential backup cannot be restored because no files are ready to rollforward

This differential backup cannot be restored because the database has not been restored to the correct earlier state

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.

Continue reading This differential backup cannot be restored because the database has not been restored to the correct earlier state

How to Backup SQL Server to OneDrive

How to backup SQL Server to OneDriveYou 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

Should You Back Up Your System Databases?

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?

Automated Database Backup-and-Restore for SQL Server

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