July 15, 2010 at 2:22 pm
I am a rookie DBA and I have a large database that I need to stripe the backup to improve backup performance/file size. What I am trying to find out is if in the maintenance plan wizard is there a way to have the striped backup files automatically generate the date/time in the file name like they do for non-striped backups?
Thanks
Sherri
July 20, 2010 at 5:50 pm
Sherri Barkley (7/15/2010)
I am a rookie DBA and I have a large database that I need to stripe the backup to improve backup performance/file size. What I am trying to find out is if in the maintenance plan wizard is there a way to have the striped backup files automatically generate the date/time in the file name like they do for non-striped backups?Thanks
Sherri
[font="Courier New"]I am NOT a big fan of using Maintenance plans and most of the time try to steer away from these. While MP get the basic job done, any customizations are almost impossible to get it done. And to your specific question, I don't think it is possible to do that in MP.
There are many good scripts for database maintenance and would recommend to using them instead of MP. Tara Kizer, Michelle Ufford, Ola Hallengren[/url] have good scripts and I use Ola's scripts in all of my servers. All of them are good quality scripts.
[/font]
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 21, 2010 at 3:28 am
I have a parameter for backup striping in my script.
EXECUTE dbo.DatabaseBackup @databases = 'AdventureWorks',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@NumberOfFiles = 4
http://ola.hallengren.com/sql-server-backup.html
Ola Hallengren
July 21, 2010 at 6:27 am
Thank you both for your answers. I was figuring I would have to write a script to accomplish what I was trying to do but I wanted to make sure there wasn't an "easy" way within the maintenance plan.
Sherri
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply