For those who wonder what happened to me. We lived with the nightmare for years. Backing up, restoring, application updates, etc. were all major problems.

Finally after years of complaining...

My main problem is that without autoclose or something to unload the servers or stop and restart the instance, the server would crash or at least the backups would fail.

I had...

I never knew about this stored procedure before. It might come in kind of handy in the future.

As far as the timing etc. I have some questions. If I use...

I probably did not explain myself very well, Sorry.

I just want to get the same kind of information that normally shows up as...

At this time I really shouldn't mention who the manufacturer of this software is. Lets just say that they are one of the larger developers of specialize software for our industry....

To clarify a couple of issues. The application is a totally re-written and updated version of an existing application that we have been using for a couple of years....