Maintenance script

I found a great maintenance script for backup, integrity check and index optimization in SQL Server 2005 and SQL Server 2008. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.

You can read about it and download it here

Paul S Randall has an interesting article here about validating backups. It´s good to have a reminder about that sometimes, even if we know how important it is.

Regards
Stefan