The answers are in the books

http://www.sqlservercentral.com/store.

Or cut logs more often (back them up) and copy them to another file system.

Maybe slightly dated:

http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

I do think that Open Source has a place. And I certainly would like to see SQL Server as a Shared Source with customers that can afford to and want...

AFAIK, Derrick is correct. This makes it look like it's just an admin action

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx

Put the simple script in a stored procedure?

There is no way to do this and the big guys, SAP, Oracle, Peoplesoft, etc. don't try.

I can always run profiler and see which queries you send and what data...

There is nothing in the error log about startup? Have you checked the disk for problems?

Thanks for the comments and they are interesting. I think the fact that just about everyone is a technologist is key. Can you imagine this if you had lots of...

http://www.databasedaily.com, another site run by this one.

Thanks for the followup and good luck with the unit.

Steve

How big a DB? Is this just reporting services? Are these complicated queries? Hard to recommend hardware. Can you estimate based on existing OLTP hardware?

At a min, I'd go 2CPU,...

Tape is fine and most people still use it. It's one of the cheapest ways to get a backup offsite (you do take backups offsite, right?)

I've had this same issue,...

I do test some things on the test database, however copying the query over and running it on the production database would still have caused the issue. It wasn't that...

Thanks and I am glad. That one wouldn't have been quite as fun to fix