Barkingdog
SSCoach
Points: 18670
More actions
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
Andy Warren
SSC Guru
Points: 119902
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
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Steve Jones - SSC Editor
Points: 734418
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply