Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
 Posted - 2008-10-07 : 08:22:50
|
| Good morning,I have a db maintenance plan that is backing up the tlogs every 4 hours. Previously this was a stand-alone job, not bundled as part of the larger Maintenance Plan. Since making this switch, I see no means of setting the .trn files to overwrite each other. The drop-down box to choose Append or Overwrite is greyed out.This is my first experience with Maintenance plans. Previously I would have broken each step into an individual job, and in the case of the scenario above added "WITH INIT" to the job.Any suggestions??Many thanks to all who respond. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-07 : 09:17:02
|
| Have you applied Service Pack 2 for SQL Server 2005? |
 |
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
Posted - 2008-10-07 : 09:19:23
|
quote:
Originally posted by sodeep
Have you applied Service Pack 2 for SQL Server 2005?
Affirmative. SQL2K5, sp2. |
|
|
|
|
|
|
Maintenance Plan with Append