I am using SQL Server 2008. I am trying to create a new Maintenance Plan. I create the plan, and then add a backup database task to the plan. When chosing Databases to backup, if I chose "All Databases" or "All user databases", and then
click OK, the UI hangs for a while, then eventually, it comes back with an unhandled exception. If I look at the details, I see the following exception:
Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not
If I chose the option "Choose databases" and pick databases to backup, things seem to work just fine. New databases on are added to this server on a regular basis. I do not want to maintain the list of DBs to backup. Any suggestions?
View Complete Post