Exit Code 850 Stored Procedure
matt_65
Posts: 8
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:
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
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
Comments
Please can you send across some more information:
1. Exact error on failure
2. Version of SQL Server
3. Exact version of SQL Backup 6.x
4. The latest SQL Server logs
5. The SQL Backup logfile from the failure.