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 |
|
vijay_nd
Starting Member
1 Post |
 Posted - 2008-02-13 : 07:04:35
|
HI,We have a SQL SERVER 2000 and have few databases running on it.I have created a Maintenance plan on it which is scheduled to take database backup, transaction log backup every day, delete 2 days BAK and TRN files. Its working fine. My problems are as below :1) There are few earlier backup schedules created on individual databases. I need to delete these backup schedules as my Maintenance plan works fine. How do I remove previous backup schedules ? Because of this duplicate backups are created which eats up my HDD space.2) While Maintenance plans works fine, it does not delete TRN files more than 2 days old as specified in the plan. Why ? Thanks in advance to reply my queries.Vijay |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:58:54
|
| 1. right click on the job and choose delete in em.2. check plan's log file, it tells you why. |
 |
|
|
|
|
|
DELETING BACKUP SETTINGS