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 |
|
NN2
Starting Member
2 Posts |
 Posted - 2008-10-24 : 08:30:20
|
| Hi, I have created a weekly backup plan where both the data and transaction logs are backed up. I have also created another plan to do some house keeping on some asp.net membership tables which I want toschedule for every fourth week or so. My question is, I want the 'house keeping' plan to execute only after the backup plan has completed for that particular week, but I can't see how associate the two plans. I'm sure this has been made more easy in version 10 as I see you can create sub plans, but I'm struggling to achieve this in version 9. Any suggestions wba.Regards,Mark |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-24 : 08:34:45
|
| Use SSIS package for maintenance plan instead of MP wizard.You can do whatever you like with SSIS package. |
 |
|
|
NN2
Starting Member
2 Posts |
Posted - 2008-10-24 : 09:03:10
|
| Ah, ok.. I did read that you could use SSIS and create MPs. Thanks I'll take a look at SSIS. Another thing that's bugging me is on the topic of bulk deletions. I keep reading in the 2005 BOL that the truncate_only option for 'backup log' will be axed in future versions (which I'm guessing means it has disappeared in 2008?). If I need to do bulk deletions I don't want to have those transactions recorded in the log file because I would never really want to replay them in the event of a recovery, question is how else do I achieve running bulk deletions without having them logged??Mark |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-24 : 09:06:53
|
| change your database to simple recovery model and do bulk deletion if you don't care about point in time recovery.It controls your log growth. |
|
|
|
|
|
|
Maintenance Plans in 2005