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...
Server Database Backup
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.