Thank this author by sharing:
By Carolyn Richardson,
One thing I've noticed as a contractor is the inconsistencies of the configurations of SQL Server installs. So now I ensure I always follow some basic steps, when I arrive at a new company, some of these apply to new server installs as well.
Are there any database standards?:-
Reindexing/deleting files, retaining history
This list can be endless, but concentrate on the necessary first then move on to the nice to have jobs after.
Check are alerts set up?
Is database mail set up?
Is MOM being used?
Should alerts and failures send you an alert?
I do a number of other things relating to monitoring events using Reporting services, but I'll save them for another day. If you want to add anything to the list I would be grateful for the input.
Database creation and backup alert
Learn how to write a script for regular database backups using Powershell and SMO.
Script to get the database backup history on SQL Server 2000/2005/2008
We all know the importance of taking regular backups of our SQL Server databases. This is a useful l...
Find databases without backup and alert you by email with databases affected