Followup: The hanging multiple processes "sqlmaint" occurred again.

I seperated out a backup of the largest db into another seperate maintenance plan and ran it a few hours earlier.

This...

Hello all have same problem on a couple of servers.

In Task Manager- Processes. I stopped slqmaint - which had multiple instances running and it cleared the status in...

re: MSDTC on server

Yes it is running (and I bounced the service, and then the whole server a few times)

Not sure what you mean by server-server time?

Not...

Something that I don't understand.

In a production environment the failed database cannot be renamed to something else (too many connection & application stuff would be dependant on the database name.

So...

I too am very curious why the detach/attach method (removing the location parameter for th ldf) did not work.

Having done this many times for clients with non-maintained trans...

Having been on both sides of the "consultant" question here's my 2 cents.

I'd like to meet the person(s) who know everything walking into a project. However when paying large...