|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/18/2012
Posts: 1
|
Hi
First all excuse me english. I don't know speak english very well...
My problem: How can i restore my database using a full backup and
diffencials backups?
Any detailed instructions how to do this?
I know that the one click restore only work with full backups.
Thanks.
Bionan
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 7/12/2012
Posts: 103
|
Dear Bionan, Please, find examples and step-by-step instructions on http://msdn.microsoft.co...s/library/ms175510.aspx
Correct, One Click Restore tool works just with full backups.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 937
|
When trying to restore a database copy of the differential backup that is stored in a separate file, often get "Can not restore the log or differential backup, because no files are ready to rollforward."
How to fight it:
1. Run MS SQL Manager
2. Choose from a list of available databases, the system database and call the query window. If you try to run a query in the box was called by your database will get a message that the base is already being used in the session.
3. Run the query
restore database DBNAME from disk = 'c: \ DBNAME.bak' with NORECOVERY
restore database DBNAME from disk = 'c: \ DBNAME.df1' with NORECOVERY
restore database DBNAME with RECOVERY
And one more thing. Backups must go in order, otherwise you will still get an error saying that no part of the data to be restored.
|
|
|
|
|
