Search
InstantDoc ID
GO

Browse By: Author | Issue

March 23, 2004 05:23 PM

Inside Database Maintenance Plans

Automate and monitor maintenance tasks for smooth performance
Rating: (0)
Roman Rehak
SQL Server Magazine
InstantDoc ID #41844
Regular maintenance is essential for the smooth, successful operation of your databases. This maintenance includes making backups to protect against data loss, performing consistency and integrity checks to ensure your data and indexes aren't corrupted, and regularly rebuilding indexes to help you compact and defragment your data. SQL Server database maintenance plans help define, automate, and monitor these maintenance operations. The Database Maintenance Plan Wizard, which walks you through th...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

John - No, because a logical backup device is pretty much just a single file. Backup files created by maintenance plans have file names generated at the time they are created using a unique timestamp. So each backup plan creates multiple files and there is no way to direct them to a single file.

dbeDan - Yes, you can do this with a custom script, see my blog about this: http://sqljunkies.com/WebLog/Roman/archive/2004/11/20/5223.aspx

RomanRehak 6/29/2005 11:24:20 AM

How Can I select all dbs, so thate any new dbs created will be a part of maintenance, but exclude a specific db such as pubs from the maintenance plan. I want to do this particularly for backups.

dbeDan 8/17/2004 12:50:30 PM

I am some what new to SQL Server. I found this article very informative. Please keep articles of this nature coming.

Doug Cosgrove 4/29/2004 8:33:03 AM

Excellent article, thanks!

I was wondering, is there a way, using sqlmaint (xp_sqlmaint) to direct the backup to a logical backup device instead of to tape or disk file?

John Meola 4/23/2004 10:15:21 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.