Restore doesnt finish.. it just keeps going on and on and...
We have been backing up with SQL Backup for months now.
Successfully restored to a spare box as part of our test Disaster Recovery during our trial.
However, we now have a real need to restore a production DB backup and SQL Backup is not working.
(The Restore job just keeps going on and on - just like a whingeing customer, it never ends!)
Here's what we did:
I copied the production backup .sqb file to the standby server, which also has a licensed copy of SQL Backup Lite.
Ran the SQL Backup Restore wizard and then copied the script to a Job in SQL EM.
Heres the script:
master..sqlbackup N'-SQL "RESTORE DATABASE [CATSites01FailOver] FROM DISK = ''D:\Backups\FULL_(local)_Production_20080309_180001.sqb'' WITH NORECOVERY, MOVE ''CMS_Data'' TO ''F:\Databases\ProductionFailOver_Data.MDF'', MOVE ''CMS_Log'' TO ''C:\DataLogs\ProductionFailOver_Log.LDF'', MOVE ''CATSites01_1_Log'' TO ''D:\DataLogs\ProductionFailOver_Log.LDF'', REPLACE"'
The DB size is 11GB compressed 64GB physical disk space for MDF, with two logs on different mirrored drives (about 11GB of LDF).
When the SQL Job runs, I can see all the file devices being created and in SQL EM, the Database (Loading) then the job just keeps running and running and running.
I had to kill the job two nights ago, BY stopping the Redgate Service. Then noticed a new version of SQL Backup and upgraded to 5.3.
I ran the job again with SQL Backup 5.3 (after deleting the DB from EM and creating a new Restore job using SQL Backup Restore Wizard).
The standby server works fine when I restore a MS Native Backup.
Its definitely a SQB related problem during the restore process.
BTW: backups using SQL Backup happen everyday, they're worthless if I cant restore!
This is a bit of a nightmare, because we're now reliant on the extra space savings SQL Backup 5 gave us, for other things.
PLEASE help me resolve this. Has anyone else had this problem?