Comments
Sort by recent activity
That's perfect, thank you so much. / comments
That's perfect, thank you so much.
All,
I figured it out.
Thanks / comments
All,
I figured it out.
Thanks
Sure, below is the code,
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [DB1,DB2,DB3] TO DISK = ''C:\Backup\Full\<database>\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 1b, PASSWORD = ''<ENCRYPTEDPASSWORD>xxxxxxxxxxx</ENCRYPTEDPASSWORD>'', CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, KEYSIZE = 256, THREADCOUNT = 23"', @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
I also double checked and no tape backups are running or did run at the same time. / comments
Sure, below is the code,
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [DB1,DB2,DB3] TO DISK = ''C:\Backup\Full\<database>\<AUTO>.sqb'' WITH ERAS...
Thanks epetro, I thought of something like that too. It's not super clean but it should work for our office. / comments
Thanks epetro, I thought of something like that too. It's not super clean but it should work for our office.
I'm guessing I might just have to accept this as a possible issue with restores? / comments
I'm guessing I might just have to accept this as a possible issue with restores?