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?