Good article. And good discussion. Your point “Don’t risk more than you can afford to lose” is so fundamental to the developer and DBA, but also the business....

Steve,

I am very sorry for your loss. My prayers will be with you and David's family today. Thank you for your all your good advice. I really enjoy your...

If you have limited bandwith, you could zip the backup to make it smaller.

Keep in mind, it will take some time to zip and unzip the backup, so this...

Nice article, David. Good problems solving skills.

Our biggest is a SQL Server 2005 database server with 32 GB Ram, 8 Cores, 200+ GB data

A couple of things come to mind, but one feature I have started to rely on this year was the Blocked Process Report. It takes a bit to get the...

I do a lot of cycling and would like to ride more. Maybe I can start competing in the spring if I ride enough over the winter. Often I cannot...

Kenneth Wymore (12/3/2010)

Do you have a link for this...

I like to listen to music, talk radio, or some type of background noise that does not distracting, when I am coding and doing routine tasks. When I have to...

Excellent. Thank you Shawn and Derrick. SSC never fails me. This is exactly what I needed. For some reason I couldn't find it in BOL or Google.

http://msdn.microsoft.com/en-us/library/ms191291.aspx

The REFERENCES permission...

@AndrewJacksonZA - I don't know what is more disturbing, just seeing the name "Rick Astley" :sick:, or that you know the words? 🙂

Anyway, this is an old...

I have always been a Captain America guy for the exact same reasons as Andy, patriotism and moral character.

Rdevitta,

You have me stumped there. I assumed you posted this question in "SQL Server 2005 Integration Services" forum where there will be better SSIS experts than me.

The only thing...

rdevitta,

Your error is similar, but the source is definitely different from our cases. I am not sure what would be causing your error, however, the first thing I thought of...

Thank you, Sunil. It is good to have some conformation from someone with similar problems. Glad to hear there is an improvement.

I am curious, are your jobs executing SSIS...