Not able to restore differential backup

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Not able to restore differential backup

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-04-15 : 00:21:02

Hi,

I am not able to restore a differential backup.
i guess we can restore a single differential backup
I have two server on the same machine .i am able to restore full backup just by changing destination physical file name.
but unfortunately i am not able to do the same in the case of differential backup.
Error says to select no recovery option
i guess i m doing that by selecting following option
Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)
Please help what i am missing

Thanks in advance

Kristen
Test

22859 Posts

Posted - 2007-04-15 : 05:33:12

First restore the FULL backup (from before the Differential backup). Use the NORECOVERY option.

Then restore the DIFFERENTIAL backup. Use the RECOVERY option.

See also:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-05-06 : 19:54:00

sorry for the late reply
It worked
thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources