Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the growth of how to obtain the database through backup records, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

Usually people want to know if the database has grown and how much it has grown. You may want to compare it with the size of each historical period of the database. But how can we get the size of these historical data? There seems to be no good way to understand the growth of the database by looking at the backup records.

First of all, we should back up the database frequently, which can be implemented with Job. The backup records of the database are saved in the backupset table of the msdb database. By looking at the backup records, we can get a rough estimate of the growth of the database.

The script to view is as follows: select BackupDate = convert (varchar (10), backup_start_date, 111), SizeInGigs=floor (backup_size/1024000000)-- convert the size to GB units from msdb..backupset where database_name = 'DatabaseName'-- the name of the database you want to view, replace and type =' d' order by backup_start_date desc

The output is as follows: BackupDate SizeInGigs 2009-06-22 2 2009-06-04 1

After reading the above, do you have any further understanding of how to get the growth of the database through backup records? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.