How can we help you today? How can we help you today?

SQL Backup returns exit code 0 but database is SUSPECT

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
psribeiro
0

Comments

1 comment

Add comment

Please sign in to leave a comment.