March 4, 2007 at 6:02 am
I've been trying to figure this problem out for the past few days. I have a production server and a standby server. There's a job on the standby server that creates a full database backup and stores it to my standby server. I also have another job on the production server that runs a differential database backup, and also stores it on the standby server. The full backup is run 3 times a week (Mon, Wed, Sat). The differential is run every hour.
On the standby server, I have a job that restores the full database backup, and I don't have any problems with it. I'm running into trouble when the restore for the differential database is run. The following is the script that I've written:
RESTORE DATABASE XYZ
FROM DISK '...\differential_database.BAK'
WITH RECOVERY
Please note that the full database is run WITH NORECOVERY. If someone could help me with this it would be great...thanks in advance.
March 7, 2007 at 6:24 pm
Hi there,
Do you have the output from the command - IE any errors reported. You probably dont want with recovery because as soon as you issue a command using WITH RECOVERY you can no longer restore any future differential backups. If you need access to the database then I would suggest using WITH STANDBY=<undofile> which will put your database in a read only state but not allow it to be changed so you can restore future differential backups.
Let us know if this helps otherwise post the error messages you see when you run the command.
- James
--
James Moore
Red Gate Software Ltd
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply