Monthly Archives: May 2012

Sql Server Status

What’s the first thing you do when you get a report of a problem on one of your servers? In my case… i run this following script that gives me a quick overview of all the top counters of interest.

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

Backup Script to replace xp_sqlmaint

Need a backup script because xp_sqlMaint is not running on 2008? Try this one. You need only fill in the database name and directory name in the appropriate places below:

Posted in SQL 2005, SQL 2008, SQL Administration | 1 Comment

Out of disk space…Log file grown too big?

It’s early in the morning, and you’ve got disk space problems… log file, right?  Yep.   OK, we need a script that will tell us what we need to know ASAP.  Since i experienced this issue multiple times…and since they always … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration, Uncategorized | Leave a comment