What are the challenges you face when working across database platforms? Take the survey
Options

Exit Code 850 Stored Procedure

matt_65matt_65 Posts: 8
edited November 18, 2009 10:34AM in SQL Backup Previous Versions
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

Comments

  • Options
    We have done a quick test on this scenario in SSMS but cannot reproduce the error.

    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.
Sign In or Register to comment.