January 18, 2008 at 1:28 pm
ok, just made my first maintenance plan in SQL Server 2005. In 2000, when you finish the plan, it breaks it out in the JOBS as backup, optimization, integrity check and Transaction log backup. You can specify how often to do the backup and the transaction backup. I just found that there was no where I could set how often to do the transaction log backup. As it looks, it will only be done once a day with my full backup. I normally do a full once a day and transaction every hour. Are you suppose to break out the transaction backup to its own job? Should I not have included it in the Maintenance Plan?
HELP!!! I don't want to mess up here!!
thank you!!
January 18, 2008 at 1:35 pm
Personally, I'd just set up a separate job to back up the transaction log, and schedule it to run as often as you feel is necessary. Don't take it out of the maintenance plan, just add another job on a more frequent schedule. Should be pretty easy to set that up.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 18, 2008 at 1:52 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply