Restore job is hunged....

faisfais Posts: 21
edited April 23, 2009 5:16AM in SQL Backup Previous Versions
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.

Comments

  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.