@Gaz....

Yes I know DBA's, especially really senior DBA's tend to be very "cagey", some even difficult to approach. Unfortunately, this tends to be part of the personality profile of Administrators...

Interesting editorial.

Failover clustering works, why not apply the same principal this issue?

Any company that has a single point of failure is asking for trouble....:-)

Thanks for this, I was really looking for an eplainantion in the simplest terms and this article provided it. Looking forward to more on this topic.

I work for a consulantancy/contracting firm so right now, my billable time to a client has a direct effect on our bottom line, but in my previous job there was...

Brilliant! Too true and the comment came at a time when I was literally about to lambast a developer for not following the correct procedure. this post made me sit...

Hi

Check the fragmentation on you db files. Usually after several restores etc. and the fact that it seems to be a heavy write load on this db. Fragmentation can occur...

Hi

I had a similiar issue with an OLTP db on one of my servers, all the symptoms look to be the same. My suggestion is to investigate if the...

Hi

The process you're using sounds like alot of work. Perhaps you might want to investigate developing a log-shipping process for this. Not sure if I can add any more value...

Thanks for this Prett, I usually use the DMV's which are difficult to translate to business. Much appreciated and keep it up.

Regards,

Ronan

I like the article, thanks Prett. I would like to know though what are the drawbacks for using Maintenance Plans VS Scheduled sprocs.

Hi

It seems like you need to clean up your delimiters and there are generally two:

1. Row delimiter

2. Column delimiters

Your row delimiter seems to be a comma (,) but your...

Hi Mike

What version of SQL Server are you using?

What I would do in this situation is actually look at the string being passed to the cmdshell by adding a select...

Hey Bert...... This is an international forum you know..... as for what might have happened...... this forum might have been in Russian, German or Japanese :D, this isn't a nationality-specific...

With great power comes great responsibilty...... Some politicians haven't actually read Spiderman yet tho'. ANY invention can be turned to evil. The splitting of the atom lead to the greatest...