SQL Backup returns exit code 0 but database is SUSPECT
psribeiro
Posts: 10
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
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8