I've created a maintenance plan for many databases with these tasks (SQL 2005)
1- shrink Database
2- Update Statistics
3- Cleanup History
4- Backup Database (Full)
5- Maintenance Cleanup task
The maintenance plan failed at task Update Statics. Here the error message :
Error number : -1073548784
Error message :
Executing the query "UPDATE STATISTICS [dbo].[LOG_DETAILS]
" failed with the following error: "Could not continue scan with NOLOCK due to data movement.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
My question :How do I know which database is causing the problem and how can I fix the problem ? I don't know a dbo database?
View Complete Post