yes.

Uninstall/Reinstall - This is what I thought :ermm:

In furthering what has been said regarding the execution plans: look for any lookups and/or scans on large tables, clustered indexes, etc) paying special attention to the ones that have...

Something like this would work, just tweak it to suit your needs...I do something similar to monitor the SQL Developers when they change SQL Agent Jobs 😀

CREATE TRIGGER [dbo].[tr_NewUserRecordAdded] ON...

Haven't used Backup Exec in a few years but my guess is it doesn't perform transaction log backups at all (I'm sure it physically backs up the LDF file itself,...

Is the DB is simple, full, or bulk-logged mode?

If in bulk or full mode make certain you have transaction log backups running. The "standard" is typically every 15 minutes...

Is the LDF file 39.3MB?

Agreed. But wouldn't you agree that it would be more helpful (especially since Google is one of the best resources for finding solutions) that if you knew upfront that the...

How awesome would it be for this site to have an option to "close" or "resolve" button for threads???

🙂

Hey No problem, it worked for me in my testing so best of luck with it!

I wouldn't recommend using percentages for auto growth options on such large DBs. For instance if you have a DB that's 100GB, has autogrowth set to 5%, and the...

Yes it will be skewed. These types of tools need to be run for bench-marking purposes prior to anything being put on the disks (so the numbers can be...

This should work...

Create a new job that has "checking" code in it that will monitor the running job. From the first job step of your existing job (or via...

Log files...

Under the SQL Server Agent Properties >> Alert System, have you enabled a default mail profile and selected the proper fail-safe operator?

With jobs, it works (as each job/job step is a separate "batch", however when executing stored-procedures within the same session SQL processes every batch sequentially (to adhere to ACID) and...