Dumping tran log after backup with sqlmaint

  • Our database is using a generic DB Maint Plan for our backups. I would like to dump the transaction log after it is backed up to free up space. Is there a switch with sqlmaint to do this? I could not find one. Thanks.

  • The backup db and backup log do different things. Dumping the log will not free up space in the database. If you are running log backups (full or bulk mode), then the log space is being freed and reused. If you are in simple mode, you don't need log backups. The log will keep itself trimmed.

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

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