How to find out which database grow most?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 1

Short answer, look at the backup sizes and determine which one is adding data the quickest.

nagkarjun1 Ten Centuries Points: 1020 More actions · Answer 2

steve,

Thanks for the reply

I need the information of last two-three months. is there any way to find it?

Backups are of only 7 days.

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 3

You can use the backup_size column in the backupset table in msdb to look at size for backups you don't still have in the file system.

Cheers!

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 4

If there are only 7 days, do you mean 7 days in msdb? If the data is gone, it's probably gone.

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 5