Welcome to

SqlServer-QA.net

Sign in | Join | Help

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.

Here is the list of new links from Ola:

Ola's Homepage  & About

Solution Documentation

Solution scripts

 

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.

 

 

Published Monday, September 29, 2008 12:15 AM by SQL Master

Comments

# SQL Server 2008 (SSQA.net) : Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

# 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

Monday, September 29, 2008 12:27 AM by Other SQL Server Blogs around the Web

# Adhoc solution to perform SQL Server database maintenance tasks - more features

I had been receiving a good feedback about the solution that has been posted previous about Script to

Monday, June 08, 2009 2:19 AM by SQL Server Storage Engine & Tools (SSQA.net)
Anonymous comments are disabled