You cannot delete the log. It is an open file that is essential for the database to function.

A database cannot run without a log file.

Dan,

Are you accepting cookies? I use IE and Firefox and remain logged in with cookies setup. It's likely a security thing on your side and I wish I had a...

http://www.sqlservercentral.com/columnists/sjones/20010422115754_1.asp

Part 1 deals with users.

You can use a third party (Log PI, APEXSQL Log, or something like that). Or you can run Profiler and see what happens during that hour.

IIS allows an account to be specified for anonymous users. Be sure this is a basic domain account with only the permissions needed to access only the data needed.

Timeframe is this month, though feedback from SP1 could change that.

Not sure where that thread is, but you can use it. However, if things need to move there, then what happens to developement? Does it stop? Do you lose work?...

Before you restore a diff, you need to restore a full.

You also might choose to split up the tables on different periods. Heavily hit tables might be in a script that runs every night. Less used might be scheduled every...

Correct although in keeping with minimum permissions, you would not choose the Reader role. It gives permissions to multi-server jobs and this question mentions local jobs only.

I agree with the above. The transactions/sec is not indicative of a problem. It shows the amount of work being done in that database. And your application shouldn't be competing...

It might be just the expected load on that hardware with that number of users. Or it could be something you can reduce.

60-80% is less than 100%, which is where...

Besides the missing WHERE clause? On both updates and deletes?

Of course, I'm a production DBA. And I've had some good ones, fortunately with small databases.

- Restore QA over production by...

Everytime you execute an insert, update, or delete, MORE infromation is written to the log. That's what it is, a log of activity. When you take a log backup, these...

Login failed is a different message than the name resolution. It means the context of the package execution is running under a local or non-network account.

I suspect that you resetting...