Maintenance plan failed - db in single user mode
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'.
-Steve
-Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it is still running............and the disk i/o is changing then it is still progressing.
How long as it been running..........(is there enough space for the backup to be done....)
Are there any locks on the database at all?
If you can leave it for a while...i would do that...............
I have in pass deleted a backup and had no problems..........(but if you can leave it then i would until say end of today and see if it has finished....? ) is that possible.....
Is the backup bak grewing....in size ...as it backups.
How long as it been running..........(is there enough space for the backup to be done....)
Are there any locks on the database at all?
If you can leave it for a while...i would do that...............
I have in pass deleted a backup and had no problems..........(but if you can leave it then i would until say end of today and see if it has finished....? ) is that possible.....
Is the backup bak grewing....in size ...as it backups.
Oh i see its doing a optimization attempt to repair and minor issues.......and a backup....
on a 100 gig database...........hmm that could take some time....
Is there any thing on the error logs by anychance.....and check the locks.....also.
on a 100 gig database...........hmm that could take some time....
Is there any thing on the error logs by anychance.....and check the locks.....also.
ASKER
It started about 10 hrs ago - and the maint plan history shows it tried to repair 19 seconds in. I was working with our sys admin - he killed a 3rd party backup job that was hanging too. Next time I checked sp_who2, it was done. I then changed it to multi user and it's fine.
Thanks for your help - I'll look into kill spid to see what it might do.
Thanks for your help - I'll look into kill spid to see what it might do.
No problem...if it seems to be running just do not kill....that my kind of rule...
ASKER
I wasn't the one who set up the plan - it's supposed to simply be a backup.
Is there anything bad that can happen if I kill spid?