Managing Backup History Options in MSDB

Question

Managing Backup History Options in MSDB

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
July 31, 2024 at 12:00 am

#4429876

Comments posted to this topic are about the item Managing Backup History Options in MSDB

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

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

Neil Burton SSC-Insane Points: 23009 More actions · Answer 1

This proc allows you to delete by database which, according to the question as written, is managing the amount of data. While it doesn't do the same exact job, to me, it doesn't look like it's wrong to say that there are two options. Could somebody explain the difference please?

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

ako58 SSCarpal Tunnel Points: 4033 More actions · Answer 2

sp_delete_database_backuphistory [ @database_name = ] N'database_name'

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Sorry, typo. Meant to include the proc name in the question. Points awarded back