no probs!:satisfied:

running sp_helpdb won't impact your prod run. if you only run every 3 hours you have a 3 hour winwindow to search for the change to recovery mode, I would...

Mh,

if you are sure you have identified the stored proc altering database the only event you have to capture is stored procedures\sp:completed. This will tell you when the stored proc...

well if you've got sp_completed and sqlstatement completed (or whatever called - pushed for time here), it should be in there.

run your tlog backups through the night or schedule frequent...

what events are you tracing? Can you see the stored proc being executed and tie that in with the time log backups starting failing?

no probs. BORK stands for Back Office Resource Kit. Which is basically a load of material, CDs you get if member of MSDN, or premier support, can't remember.

These scripts actually...

if you still want these, scripts attached

Drat, you got me. I over thought myself, I knew it was an estimated plan, but then I was thinking surely most times the estimated plan is the actual plan...

I use the tran log shipping in 2000 Se created from BORK. gives you everything you need and works fine, in fact I prefer it to the wizard version in...

not at the office at the moment to check details but I have used sqlio to stress test the io system and it works well. The readme file you get...

Brian, I understand what you are saying, but along with the risk is the LIKLIEHOOD of the risk occurring and leading to the effect described. It seems to me this...

some apps include processes to run their own db maintenance. maybe there is a stored proc in the database which the app runs to do this.

quick and dirty check run...

you mention you want to do this in a restored database. If this is because the users have become orphaned use 'sp_change_users_login' to re-synch them rather than drop\recreate.

If thats not...

could you in fact be recording two seperate blocking chains occurring at the same time?

that article says 'not all databases should be owned by sa' which to me does not have the same meaning as 'do not have sa as owner of all databases'.

the...