December 9, 2010 at 4:09 am
hi All,
Pardon my ignorance to what could be a really stupid question to all you DBA's out there , the maintenance plan wizard options allows you to choose backup database and backup tran as part of its shopping list . However if you wish to backup database daily and backup tran log every 4 hours, then do you need 2 seperate plans to run as different jobs right ?
Or can you in the same plan have the database backup do its stuff daily with all its intregity checks and update stats etc and just have the tran log backup every 4 hours.
Also thinking out loud having a database backup followed immediately by a tran log backup which the wizard allows you to do serves no purpose, since tran log gets zapped after a full database back up anyway ?
I am assuming a full recovery model...
many thx
December 9, 2010 at 4:46 am
Pardon my ignorance to what could be a really stupid question to all you DBA's out there , the maintenance plan wizard options allows you to choose backup database and backup tran as part of its shopping list . However if you wish to backup database daily and backup tran log every 4 hours, then do you need 2 seperate plans to run as different jobs right ?
Or can you in the same plan have the database backup do its stuff daily with all its intregity checks and update stats etc and just have the tran log backup every 4 hours.
Also thinking out loud having a database backup followed immediately by a tran log backup which the wizard allows you to do serves no purpose, since tran log gets zapped after a full database back up anyway ?
I am assuming a full recovery model...
many thx
You can either setup two seperate plans one for the full backup schedule and one for the TLOG backup schedule or you can have one plan and split them into "Sub_plans" which will then run on different schedules
Full backups do not "blat" the transaction log. I wrote a post on this for TSQL tuesday a while back you can find that here: http://www.gethynellis.com/2010/10/tsql-tuesday-misconceptions-in-sql.html
Gethyn Elliswww.gethynellis.com
December 9, 2010 at 5:08 am
many thanks Gethyn...so having sub plans is the trick i guess...will also read yr blog
December 10, 2010 at 7:34 am
Please do yourself a favor and avoid maintenance plans altogether! Get the suite of free maintenance scripts/jobs at ola.hallengren.com and learn to use the incredible goodness there.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply