Restore job is hunged....

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:

&#91;code&#93;EXECUTE master..sqlbackup 
N'-SQL "RESTORE DATABASE DB_1 
FROM DISK = ''\\backuploc\backup_current\servprod\DB_1
\FULL_&#40;local&#41;_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''&#91;/code&#93;

"'

Please help.
Thanks.

fais April 20, 2009 16:04

Comments

1 comment

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

priyasinha April 23, 2009 05:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Restore job is hunged....

Comments

Add comment