Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
The log or differential backup cannot be restored because no files are ready to rollforward Options · View
Previous Topic · Next Topic
Dave
#1 Posted : Monday, June 27, 2011 3:40:37 PM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 732
When I try to restore the differential backup I get the following error:

Restore failed for Server '.\sqlexpress'. (Microsoft.SqlServer.SmoExtended)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward. (Microsoft.SqlServer.Smo)
Back to top
  |
ruslan
#2 Posted : Monday, June 27, 2011 3:45:06 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
To restore a diff backup you must first restore Full backup with NORECOVERY option (you have forgotten this option), then Diff backup. See MSDN or example
Back to top
 Report Abusive | Report SPAM | Edit by user: Monday, June 27, 2011 3:46 PM | Reason: Not specified
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.