Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008
In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking to handle these important tasks in hand with the scripts and not to leave to the GUI or API based lists.
With the release of SQL Server 2008 RTM Ola has worked out further by providing further support of these scripts in SQL Server 2008 such as case sensitive instances, unicode characters and object and database names with single single quotes ('). Also fixes to the issues surrounding the SIMPLE recovery model and Transaction log backups and for more information this new release notes refer to SQL2008 based scripts.
I hope you will find the scripts with support to SQL Server 2008 version, don't forget to test them and you can even modify according to your environment. Don't forget to leave a feedback on these scripts that will help the author to fine tune any issues.
