Forum Discussion

Mhystique's avatar
Mhystique
Level 3
11 years ago

Database maintenance failure: Query timeout expired

Hi, for the past 2 weeks, we have had some major issues with our backup, as the database got to the max size for an SQL Express. After some troubles we managed to move the database to an full SQL Server on another server. Finally resulting in backup jobs to work Again. But now I see that the database maintenance job isn't working, and I'm thinking that perhaps can explain why databse grown to max size. I need the maintenance job to Work, but can't find any solution, so here I am, hoping you guys can help. This is what the latest job said: * Saved contents of BEDB database * Optimized BEDB database size from 4338.63 MB to 4266.19 MB * Deleted expired data for BEDB database: 0 empty legacy backup-to-disk folders were deleted 0 expired reports were deleted 42 expired job histories were deleted 122 expired alert histories were deleted 45 expired job logs were deleted Maintenance has failed: -536837662, -536837662: :: -2147217871:Query timeout expired Total elapsed time: 00:09:31 How do I fix that?

Backup and Recovery
Backup Exec
Error messages
Troubleshooting
Windows Server (2003-2008)

4 Replies

Sort By
  • Jaydeep_S's avatar
    Jaydeep_S
    Level 6
    11 years ago

    See if this technote fits the exact error that you get. If so, open a support case as the issue is still being investigated.

    http://www.symantec.com/docs/TECH201551

    You could also stop all Backup Exec Services (Including SQL) and then perfrom a manual repair and maintainance of the BEDB

    http://www.symantec.com/docs/TECH67239

    If the manual cleanup and maintainance fails better oopen a support case

  • Rahul_Kumar1's avatar
    Rahul_Kumar1
    Level 6
    11 years ago

    Hi,

    Note: Make sure you stop the SQLSERVER( BKUPEXEC) service and take a copy of the DATA folder before performing this.

    Also you need to manually serach for the table having millions of entries by going to properties of each table.

     

    The following SQL script can be used to delete multiple rows of data from tables with excessive database to provide additional space for the BEDB. 

    1. Open SQL Management Studio
       
    2. Check the properties of the tables in BEDB to see which table has millions of rows. Most common are "JobHistoryDetailInfo" and "Alerts"
       
    3. Right-click BEDB and select "New Query"
       
    4. Copy and paste the script below to delete 1 million rows
    • "TABLENAME" in the scrip below should be replaced with the name of the table you want to delete rows from. Most common are "JobHistoryDetailInfo" and "Alerts"
       
    • Do not delete more than 1 million rows at a time, SQL will hang (once the query completes, you can simply run it again to delete more rows)
       
    • Starts deleting the oldest data first 

    Delete Top (200000) From TABLENAME
    DBCC Shrinkdatabase (BEDB)
    Delete Top (200000) From TABLENAME
    DBCC Shrinkdatabase (BEDB)
    Delete Top (200000) From TABLENAME
    DBCC Shrinkdatabase (BEDB)
    Delete Top (200000) From TABLENAME
    DBCC Shrinkdatabase (BEDB)
    Delete Top (200000) From TABLENAME
    DBCC Shrinkdatabase (BEDB)

  • Mhystique's avatar
    Mhystique
    Level 3
    11 years ago
    Hi, just some extended info. I don't know that the ackup Exec embedded DB is in, but throught is was an SQL Express. With BEUtility I move this to another server with a full MS SQL 2005 on it. By default BEUtility placed the DB files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. I don't what that as we haven't got much space on drive c, so through SQL Server Management Studio I detached the DB, moved the files to drive D and attached it again. For some reason when I restart the SQL and backup services, the DB files is again placed on drive C. That is my headeag right now. How do I moved the DB, so it stays there?