Hi,
I am developing a script that will make use of the SQL Backup 6 Stored Procedure to backup a specified database.
In my query I am incluiding the ability for the user to put a description, for certain DBs this suceeds and the description can be seen, however for certain DBs it fails, when I remove the description flag it succeeds.
The only difference between the DBs that fail and succeed, that I can see, is the recovery option DBs that fail are in Simple recovery mode.
The failing query is:EXECUTE master..sqlbackup '-SQL ""BACKUP DATABASE [DBMonitoring] TO DISK = [D:\Backups\Databases\DBMonitoring\DBMonitoring.sqb] WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 3, VERIFY, DESCRIPTION = [Test1234]"" '
The failing query is the exact same as a succesfull query against a DB that is in Full Recovery mode.
Does anyone know how I can get the query to work which includes the description flag?
If there is any more information required please let me know.
Matt
We have done a quick test on this scenario in SSMS but cannot reproduce the error.
I am developing a script that will make use of the SQL Backup 6 Stored Procedure to backup a specified database.
In my query I am incluiding the ability for the user to put a description, for certain DBs this suceeds and the description can be seen, however for certain DBs it fails, when I remove the description flag it succeeds.
The only difference between the DBs that fail and succeed, that I can see, is the recovery option DBs that fail are in Simple recovery mode.
The failing query is:
The failing query is the exact same as a succesfull query against a DB that is in Full Recovery mode.
Does anyone know how I can get the query to work which includes the description flag?
If there is any more information required please let me know.
Matt