April 19, 2010 at 9:31 am
I have a maintanse plan on transaction log job and I selected option to delete option with in 1 day trn,but it is not doing it,any one now why is it happening?
April 19, 2010 at 10:15 am
How is the maintenace plan configured for cleaning up the directory with the trn files?
April 19, 2010 at 10:43 am
in Maintanse plan there is an option when to expire for back up and I sat up in 1 day.
April 19, 2010 at 11:02 am
Krasavita
The expire option will not remove the backup file.
You need to use the Maintenance Cleanup Task.
Please refer to http://www.sqlservercentral.com/Forums/Topic361562-149-1.aspx
April 19, 2010 at 11:16 am
thank you
April 19, 2010 at 12:37 pm
When you specify the file extension do not include the "dot". So use BAK, not .BAK
April 19, 2010 at 12:44 pm
thank you
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply