First, it's unadvisable to shrink the log file if it grows to that size a couple of times a week. You take a major performance hit when the log...

What the previous poster said, plus OLTP or Warehouse.

There is no one size fit's all approach.

Ultimately, before anything else, you have to make sure that the environment is supported my MSFT.

It used to be the case, that on VMWare, SQL was not support in production,...

Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.

Also, copy the job...

I really don't see what the point would be. It's not really best practice to split files based ono size of the file, but instead, on the IO requirements.

When...

srinivasreddy4uhyd (3/11/2010)

---

Thanks a lot Greg. This script is really helpful.

Correct me If I am wrong.

My situation is I want to restrict group of accounts which can login from some...

I've been a SQL DBA since 1998, never taken a certification test. My resume speaks for my qualifications, not a test of theoretical knowledge that many people memorise for...

As for scaling, I am not sure how well it would handle thousands of logins per second. My best advice would be to add at the begining of the...