Hi,
Used the wizard to create a maintenance plan for a db. But it fails most of
the time. I checked the log-files.
At 1.00 AM, it runs the "Optimizations" job for 6-9 seconds. It succeeds
always.
At 1.05 AM, for 1 second, it runs "integrity check", but most of the time it
fails, and says that it couldn't switch to single-user because other users
are using the database. Thats a blatant lie though :-)
And when "integrity check" fails the "backup" job won't run at 1.10 AM. When
it runs it takes 2 seconds.
How do I find out who (sqlserver thinks) is using the database ? Is there a
logfile somewhere ? Or can I put a sp_who in the "integrity check" job ? Is
there a way to "kick out" the offending user ? Or maybe put a -kill_all on
the job ?
thx
/jima