Restore of diff backup after full hangs indefinitely.
jhboricua
Posts: 41
We're trying to restore database 'B' of the latest DIFF from database 'A'. Tried this first thru the SQLBackup GUI.
Server is a 64-bit SQL instance at SP3. SQL Backup version is 6.4.0.56 and the Service Application Version is 6.4.0.1028
The Full restores fine, but the DIFF hangs indefinitely after processing the backup file, the job never finishes and the database never comes out of 'Restoring' status.
We killed the job on the SQL Backup GUI and then tried to do it directly via SSMS. Did this by copying the command line code generated by the GUI. Same thing, Full restore completes but it hangs on the DIFF after processing what seems to be the whole DIFF file.
The step for the FULL that completes fine:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [train] FROM DISK = ''\\dwcifs01\sqlbackups01\Prod\DWSQL03\son_db\FULL\DWSQL03_son_db_FULL_20110501_044315.sqb'' WITH NORECOVERY, MOVE ''elitedbs.mdf'' TO ''H:\EliteDB\train_db.mdf'', MOVE ''logelitedbs.ldf'' TO ''I:\EliteTLogs\train_db_log.ldf'', REPLACE"'
The step for the DIFF that never finishes:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [train] FROM DISK = ''\\dwcifs01\sqlbackups01\Prod\DWSQL03\son_db\DIFF\DWSQL03_son_db_DIFF_20110502_000213.sqb'' WITH RECOVERY"'
Requesting assistance. Tried running 'EXEC master..sqbutility 9997' on another query window to see if the output would point us to a root cause but I got a NULL response.
Need this resolved.
Server is a 64-bit SQL instance at SP3. SQL Backup version is 6.4.0.56 and the Service Application Version is 6.4.0.1028
The Full restores fine, but the DIFF hangs indefinitely after processing the backup file, the job never finishes and the database never comes out of 'Restoring' status.
We killed the job on the SQL Backup GUI and then tried to do it directly via SSMS. Did this by copying the command line code generated by the GUI. Same thing, Full restore completes but it hangs on the DIFF after processing what seems to be the whole DIFF file.
The step for the FULL that completes fine:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [train] FROM DISK = ''\\dwcifs01\sqlbackups01\Prod\DWSQL03\son_db\FULL\DWSQL03_son_db_FULL_20110501_044315.sqb'' WITH NORECOVERY, MOVE ''elitedbs.mdf'' TO ''H:\EliteDB\train_db.mdf'', MOVE ''logelitedbs.ldf'' TO ''I:\EliteTLogs\train_db_log.ldf'', REPLACE"'
The step for the DIFF that never finishes:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [train] FROM DISK = ''\\dwcifs01\sqlbackups01\Prod\DWSQL03\son_db\DIFF\DWSQL03_son_db_DIFF_20110502_000213.sqb'' WITH RECOVERY"'
Requesting assistance. Tried running 'EXEC master..sqbutility 9997' on another query window to see if the output would point us to a root cause but I got a NULL response.
Need this resolved.
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8