Restore job is hunged....
fais
Posts: 21
Hi All,
We are using the restore job to restore 1TB of database from SAN.
When I use the graphical tool of SQL Backup , I am seeing that , the restore job is hunged at 318 Gigs, its not moving from there.
I also used
I also used :
SQL Backup version : 5.4.0.55
Here is the script:
Please help.
Thanks.
We are using the restore job to restore 1TB of database from SAN.
When I use the graphical tool of SQL Backup , I am seeing that , the restore job is hunged at 318 Gigs, its not moving from there.
I also used
EXEC master..sqbstatus: But its values are not changing.
I also used :
EXEC master..sqbutility 9997: Its results is NULL.
SQL Backup version : 5.4.0.55
Here is the script:
[code]EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE DB_1 FROM DISK = ''\\backuploc\backup_current\servprod\DB_1 \FULL_(local)_DB_1_20090221_080000.sqb'' WITH RECOVERY, MOVE ''DB_1_datData'' TO ''e:\DB_1_data.mdf'', MOVE ''DB_1_1_Data'' TO ''e:\DB_1_data2.mdf'', MOVE ''DB_1_datLog'' TO ''e:\DB_1_log.ldf''[/code]"'
Please help.
Thanks.
Comments
When you run
EXEC master..sqbutility 9997
SQBCoreService_bugreport.txt is generated in the folder where the SQL Backup Agent service is installed.
I would recommend you to open a support incident with support@red-gate.com and send them SQBCoreService_bugreport.txt.
Thanks,
Priya
Project Manager
Red Gate Software