Jason, Thanks for the inputs. It will do me a lot of good.

But I have some more queries boggling in my mind regarding backup strategies.

1. I'm curious to know when...

Derrick,

Thanks for the info, but i think im looking for further deep introspection into these:

1.I dont have any "maintenance window". please assume that my app is running 24*7. In this...

Hi,

Upto my knowledge, unless you have the body of the sp in a text file or something, which your ancestor have kept there is no way to decrypt an encrypted...

Hey Mike,

Thanks for the inputs. I have not yet used SQL 2005 so dont know much about Index Tuning Advisor.

But one more thing is one can't solely rely on...