Maintenance plan failed - db in single user mode
Posted on 2006-06-28
I have a maintenance plan for a large DB (100+ GB) that failed last night. I checked on it this morning and the DB is in single user mode. I have since went into the plan and unchecked Attempt to repair minor problems. However, the process is still running. How can I kill the maintenance plan to put it back in multi user mode? And are there any adverse side effects to doing that? I assume that at that point, I can sp_dboptions 'myDatabase', 'single user', 'false'.