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: 119747
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 SQLAndy - My Blog! Connect with me on LinkedIn Follow me on Twitter
Steve Jones - SSC Editor
Points: 728159
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
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply