Backup Fails (22029)

  • I had several database backups that failed on a single server. Below is the contents that was written to a log file for the job. Any suggestions ?

    Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ZCHQ_MSSQL\PRD1' as 'ZCI\SQLSERVICE' (trusted)

    Starting maintenance plan 'HazEMS33_BACKUP' on 12/23/2002 12:01:43 AM

    [1] Database ems33_backup: Check Data and Index Linkage...

    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8651: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.

    The following errors were found:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.

    ** Execution Time: 0 hrs, 0 mins, 3 secs **

    [2] Database ems33_backup: Transaction Log Backup...

    The backup was not performed since data verification errors were found.

    Deleting old text reports... 0 file(s) deleted.

    End of maintenance plan 'HazEMS33_BACKUP' on 12/23/2002 12:01:50 AM

    SQLMAINT.EXE Process Exit Code: 1 (Failed)

  • Check out MS TechNet Article 298801 or go to http://support.microsoft.com/default.aspx?scid=kb;en-us;298801

    Hope this helps.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • The SQL Box has 512MB Ram. The OS is W2K with sp3 running SQL Server 2000 standard edition with sp2.

    I had searched msdn KB in sql server 2000 for 22029 without seeing anything.

    I just checked applications in the event 'application' log and found entries regarding disk space. Interesting, the sql logs didn't report this nor was there an entry in the event 'system' log.

    I now know to check this in the future.

    Thanks.

  • Thanks for the update.

    So the issue was lack of disk space? On the paging file?

    Seems like a memory issue, like you don't have enough memory available at that time for SQL.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply