Post reply

How to delete clear space on the drive that DB's and Cubes are being backuped up to?

  • September 27, 2017 at 2:30 pm

    #340407

    Hello, Is there something in SSMS that I can use to clean up the backup directories? Like the way I can use Management in SSMS to clear our lag files? Its the drive that hold the DB and SSAS backups that overfull, and I dont want to delete with File Explorer. Thanks

  • September 27, 2017 at 11:20 pm

    #1961270

    Hi,
    we are using a procedure for Log Backups and to clean the folder using xp_cmdshell when the given timeframe is reached.
    1st step: get the folder content into a table
    2nd step: select all files which will be deleted based on the timestamp in the filename
    3rd step: delete them using xp_cmdshell

    another solution I could think of would be a powershell script to do the cleaning based on the file create date or something like that and use a jobscheduler to execute it.

    BR Gerald

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply