How to restore database programatically from backup with multiple files

Question

I have no problem with restoring database programatically (in C# using SMO) from backup containing one file. But when the backup contains multiple files (full and differential backups) I get the following error

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

So what should I do to restore database with the latest data?

How are the files laballed? If all your files were mydb.bak then no it wont know which order to do them. as only 1 can exist any point in time.. — BugFinder
– BugFinder, Commented Aug 28, 2012 at 10:49
In a backup file set there are multiple files named 'mydb-differential database backup', 'mydb-full database backup' and so on — drv
– drv, Commented Aug 28, 2012 at 10:53

Shakti Prakash Singh · Accepted Answer · 2012-10-05 03:51:12Z

1

You will need to set the NoRecovery Option so that it will allow you to restore the rest of the files.

Check this for reference.

edited Oct 5, 2012 at 3:51

Shakti Prakash Singh

2,5335 gold badges36 silver badges61 bronze badges

answered Oct 5, 2012 at 1:22

Mykre

563 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to restore database programatically from backup with multiple files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related