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 |
|
Richard101
Starting Member
30 Posts |
 Posted - 2009-03-09 : 08:11:16
|
| Hi AllI've a problem with SQL2005 maint plans. In that I cannot seem to get the tlogs to truncated.I added a subplan to my 'daily-full_&_maint' plan when I realized I'd forgot to backup tlogs.The sub-plan only has two boxes 'backup database task' and 'maint cleanup task' - and runs every 4 hrs.Within the tlog backup task, the box where I pick the database-name always changes back to "these databases" with no-tics.I've tried 'all' / 'all user' / and ticking individual databases names but nothing works.This is a bug that everyone knows about but me - right?:-)tksrichard101 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 09:49:46
|
| What SP you have for SQL Server? |
 |
|
|
Richard101
Starting Member
30 Posts |
Posted - 2009-03-09 : 09:57:16
|
| SQL 2005 Standard Edition - SP2 (9.00.3042.00) |
|
|
|
Richard101
Starting Member
30 Posts |
Posted - 2009-03-13 : 06:20:40
|
| Ok, answering my own questions then ... - In a maint-plan the 'edit' box doesn't display the previously selected database-names - only the first schedule in a plan will work - transaction-log backups won't save to sub-directories - transaction-log backups don't truncate the transaction-log, you have to use 'shrink'.full details ...http://oracle.podzone.org/node/163 |
|
|
|
|
|
|
maint-plan not truncating tlogs