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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup file Clean up

Author  Topic 

rohaandba
Starting Member

33 Posts

Posted - 2012-09-05 : 14:18:21
HI,

I have set up a 2 backup maintenanace Plans on my dev server.

One for Full backup everyday 7pm.
one for Trn backup every 30mins.

I have set up the cleanup task for deleting older than 2 days on both plans

Trn stuff is getting deleted perfect
But the Full back up (.bak) stuff is not getting deleted.

Both maintenance cleanup tasks have been set up similarlly (.trn & .bak).

Any ideas why .bak files are not getting deleted.

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-05 : 14:25:11
Try removing the "." from .bak

-Chad
Go to Top of Page

rohaandba
Starting Member

33 Posts

Posted - 2012-09-05 : 16:19:22
Thanks for the help

I was using (.) as ".bak" and I removed the dot
Now it works

Thank you.
Go to Top of Page
   

- Advertisement -