If you decide to add auditing, keep in mind the overhead this is going to create. Aaron's article is great, but read the update.

UPDATE - Mike C# and dave ballantyne...

Any reason why you chose the interval of 5 minutes for transaction log backups? You may not need to back it up this often depending on the number of transactions...

If you restart the SQL Server Agent service, there will always be something in the event viewer marked as an error. It can be a failure to authenticate the account...

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

USE AdventureWorks2008R2;

GO

IF OBJECT_ID ('Sales.reminder2','TR') IS NOT NULL

DROP TRIGGER Sales.reminder2;

GO

CREATE TRIGGER reminder2

ON Sales.Customer

AFTER INSERT, UPDATE, DELETE

AS

--add your code here

GO

Be very careful...

The inactive portion of the log is freed by log truncation. Your log is 250GB but you are no longer backing up anything in it since you already did a...

Great article. Well written. Thank you, sir.

Hmmm.. Odd... Anything useful in the SQL Server Agent Logs? What's the code you are using?

When you setup your email profile, did you make your profile public AND default?

Are all your servers clustered? There is also the option of using an SSD or a local storage solution like Fusion IO which is basically a PCI-E storage device. HP...

Silly question... Did you enable Database Mail stored procedures?

(Surface Area Config -> Features -> select your instance -> Database Engine -> Database Mail -> Check Enable Database Mail stored...

I second Jeff, especially if you are importing data in a table that already contains validated records. You are just asking for trouble. I always import the data into a...

Whichever method you choose, make sure you do your updates in one transaction. For example, if you decide to use multiple stored procs to update a record, StoredProc_1 executes successfully,...

Great article. Thanks!

Let me know if you find a solution to this. I was also looking into automating the RESTORE VERIFY.

I'm pretty sure entire books have been written on this topic. Generally speaking, you want to place your data files on a different disk subsystem than your log files. There...