Comments
Sort by recent activity
No anti-virus software, but we do have Backup Exec running / comments
No anti-virus software, but we do have Backup Exec running
Stopping Backup Exec does not resolve the problem / comments
Stopping Backup Exec does not resolve the problem
Cut and paste error, here is the command...
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXECUTE master..sqlbackup N'-SQL "RESTORE LOG [TankData] FROM DISK = [E:\SQL_BKUP\TankData\LogShip\TMC-SQLHA_SUPPLYNET_TankData_LOG__20091016_005900.sqb] WITH NORECOVERY
, MOVETO = [E:\SQL_Bkup\TankData\Tlog]
, ERASEFILES = 3
, FILEOPTIONS = 1"'
, @errorcode OUT
, @sqlerrorcode OUT;
IF (@errorcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @errorcode, @sqlerrorcode)
END
GO / comments
Cut and paste error, here is the command...
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXECUTE master..sqlbackup N'-SQL "RESTORE LOG [TankData] FROM DISK = [E:\SQL_BKUP\TankData\LogShip\TMC-S...