Activity overview
Latest activity by mraftree
Hello All,
Sorry for the scant details in my original post.
We are running SQL 2005 (9.0.3161)
We are running SQL Backup 5
We are running Windows Server 2003 Datacenter 64 Bit Edition SP1
We've got a SQL job running the following statement:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP LOGS [DB1,DB2,DB3,DB4] TO DISK = ''\\ourserver\somedir\dbservername\<AUTO>.sqb'' WITH COMPRESSION = 1, ERASEFILES_ATSTART = 14, MAXDATABLOCK = 524288, MAXTRANSFERSIZE = 131072"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Let me know if there are other details that would help diagnose this issue. / comments
Hello All,
Sorry for the scant details in my original post.
We are running SQL 2005 (9.0.3161)
We are running SQL Backup 5
We are running Windows Server 2003 Datacenter 64 Bit Edition SP1
We've got...
Memory Issues on Transaction Log Backups in SQL2005 (64 Bit)
Hello All,
We have noticed that memory is being held by the transaction log backup process and not released to SQl Server when SQLBackup transaction log backup jobs run on our production servers ev...