An easy way to track the growth of your database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sylvia Moestl... » An easy way to track the growth of your...

14 posts, Page 2 of 2

««1 2

An easy way to track the growth of your database

Rate Topic

Display Mode

Topic Options

Author

Message

rsloan

Posted Monday, June 08, 2009 7:38 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 8:01 AM
Points: 61, Visits: 72

Can the same thing be accomplished in Microsoft Access?

Post #730671

Yogesh Ranade

Posted Friday, August 21, 2009 2:49 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 6:36 PM
Points: 221, Visits: 273

nice script...i just added it to my DBA dashboard BigGrin

...i already had another but this is better

Post #775438

bpowers

Posted Monday, September 14, 2009 11:45 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 03, 2013 10:15 AM
Points: 241, Visits: 523

How could we modify the code to include the growth of the log file?

Post #787643

Michael.Beeby

Posted Friday, May 20, 2011 7:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 4:14 AM
Points: 198, Visits: 588

In the interim you could:

select BackupDate = convert(varchar(10),backup_start_date, 111), SizeInGigs=
CAST(round(backup_size/1073741824,4) AS decimal(18,4)),
backup_size AS [Raw backup_size],
CASE TYPE
WHEN 'D' THEN 'Full'
WHEN 'F' THEN 'Filegroup'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Log'
ELSE 'Unknown'
END AS Type
from msdb..backupset
where database_name = 'ROOMBOOKING' --and type = 'D'
order by backup_start_date DESC

Post #1112372

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions