Restore job is hunged....

fais

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

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.

priyasinha

Hi,

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