SQL Backup returns exit code 0 but database is SUSPECT

psribeiropsribeiro Posts: 10
edited May 23, 2006 12:24PM in SQL Backup Previous Versions
Hi,

I´m using SQL Backup 4.1 to restore files to stand-by server. The database at stand-by server became SUSPECT, but the SQL Backup restore returns exitcode=0 as everything was OK, but the database is NOT ACCESSIBLE !!!

I´m sending the command I´m using to restore, if you take a look you can see a WAIT_TIMEOUT eror, but the exit code remains 0 ????

As soon as possible give me a reply because I may be in trouble if I need to use this backups.

Thanks,

Paulo Ribeiro

##################
Command used to restore
##################

exec master..sqlbackup N
'-SQL "RESTORE LOG dbXYZ
from DISK =
''H:\DUMP_ServerXYZ_DBXYZ_2006-05-23_09-55-00-000_LOG.RGB''
with STANDBY = ''H:\UNDO_FILE_ServerXYZ.STB''"'
SQL Backup (DLL v4.1.0.207)
Error acquiring mutex: WAIT_TIMEOUT

name value

exitcode 0
sqlerrorcode 0

Comments

Sign In or Register to comment.