September 18, 2013 at 4:32 am
Hi All,
We have a DR server configured with logshipping. The transaction logs are taken from Production and copied to the DR server and restore job happens from there for logshipping. Our Production DB'ss full and txn logs are saved to tape drives on a timely basis, hence i need not worry about the txn logs copied to DR server. Now these txn logs on DR are occupying too much space as there are txn log files from past 3-4months. I want to all files older than 1 week for which i tried maintenance job but with no result.
Could somebody help me out with this issue.
Thanks,
Hari Mindi
September 18, 2013 at 5:00 am
Does your maintenance plan fail? You could add a powershell step to the job to remove files older than 7 days.
September 18, 2013 at 5:15 am
Create Maintenance Plan >> Maintenance Cleanup Task >> Delete specfic file >> Delete Older file older tha 1 month
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 18, 2013 at 8:54 am
Maintenance plan does not fail. could you please elaborate on the powershell command.
I had tried the maintenance plan which is not working.
September 19, 2013 at 2:23 am
Take a look at these links for example powershell scripts. To schedule the task add a new job step using powershell as the type.
http://gallery.technet.microsoft.com/Powershell-script-to-ed34c5f9
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply