Post reply

Dumping records from Msdb

  • December 13, 2001 at 10:30 am

    #57527

    Setting: Win 2K, SQL 2k

    We've dumped trans logs hourly from the beginning of the year. That causes our MSDB to grow rapidly and we don't need such extensive backup/restore info. How can I delete it from msdb?

    Bill

  • December 13, 2001 at 1:55 pm

    #421102

    MSDB, or the transaction log for it? Doing a full backup should purge the transaction log.

    Andy

    Andy
    Connect with me on LinkedIn

  • December 13, 2001 at 3:29 pm

    #421105

    You should be able to control the amount of history you are keeping for a database. I think a new fullbackup will clear the old history.

    Maybe this will help:

    sp_delete_database_backuphistory

    Steve Jones

    steve@dkranch.net

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

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