web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Differential backup ...
Microsoft Dynamics GP (Archived)

Differential backup & Restore

(0) ShareShare
ReportReport
Posted on by Saheed Olajide 1,145

Hello everyone,

I am trying to restore a differential Back-up from a SQL Server Database to another Database on another SQL Server. But i keep getting this error message.

"System.Data.SqlClient.SqlError: The log or differential back-up cannot be restored because no files are ready to rollforward. (Microsoft.SqlServer.Smo).

Pls, i need your assistance. It is quite urgent

Saheed

*This post is locked for comments

I have the same question (0)
  • dpitcher Profile Picture
    dpitcher 200 on at

    Saheed,

    You have to restore a full backup first with the NO RECOVERY mode and then restore the differential backup.  You could also restore any log backups if you have.  The sequence is important though.

    Darren

  • Saheed Olajide Profile Picture
    Saheed Olajide 1,145 on at

    Thanks for your response,

    Do i have to choose any Restore options when doing the FULL backup with the NO RECOVERY mode?, because i don't want to overwrite the data on the existing database. I just want to ADD the data that was backed up to the data of the other (Server) Database.

  • dpitcher Profile Picture
    dpitcher 200 on at

    No, you can't restore a backup without losing data after the backup was taken.  Backups are a snapshot of the database at a specific point in time.  Restoring the DB simply restores the data to that point in time.  Here's a link with more details: http://msdn.microsoft.com/en-us/library/ms175510.aspx

    You can restore a full backup into a new database.  That way you're not overwriting the production DB.  Then you can restore the differential backup to that new database.  When you restore a database just give it a new "To database" name and then select the BAK file.  This will automatically create a new database and restore the file you select. 

    Keep in mind the differential backup is useless without a previously made full backup.  The differential backup simply stores all changes made since the last full backup. 

  • Nithiya.veera Profile Picture
    Nithiya.veera 40 on at

    HI Saheed  well said it is working .....................................restore the differential backup

    i follow your idea thanq

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans