February 7, 2003 at 10:59 am
I have a full backup on weekends and differential backups on weekdays.
I tried to recover full bakcup with norecovery option and took the last differential file and tried with recovery option and I got this error:
One or more of the options (recovery) are not supported for this statement. Review the documentation for supported options.
Could someone throw some light on this
Thanks
Raghu
Raghu
Raghu
February 7, 2003 at 1:51 pm
How did you restore the database? If you did not specify the "with norecovery" option when you restored the full database, your database had been alreay recovered.
February 7, 2003 at 2:51 pm
From what you said I think that you restore the full with norecovery and tried to restore the differential with recovery.
You shouldn't have any error. Can you post the t-sql you used with the differential restore?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply