What would cause database to go into Single User Mode 1

[Maritime]

Hi,
I'm running SQL 7.0 and I have a number of jobs that run using DTS packages. This morning a number of these jobs failed with the error "Could not acquire a FastLoad session." I then realised that the database had gone into Single user mode. What could have caused this?

 

[JayKusch]

If you have a maintanence plan that is set up on the database to check for errors AND has the option to try and fix the errors found ... that may be your culprit.

The MaintPlan will put the DB in Single User Mode(SUM) to run DBCC commands to fix the found errors. If the errors are tough ones, I have seen the MaintPlan job fail and leave the DB still in SUM.

If you have such a job set up via a MaintPlan, view the history of the job and see if it is in deed failing.

Thanks

J. Kusch

 

[Maritime]

Hi J,
I think you hit the nail on the head. I do have a main. job with that option, and it did fail this morning, I'll have to remove it. Thanks so much.