Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How to get the database size year wise

Author  Topic 

madhukar_kcreddy
Starting Member

2 Posts

Posted - 2007-10-01 : 11:27:39
Hi
please help me as how to get database size yearly.
for example one database is created on 01/10/2000, i would like to get the db size on 01/10/2001, 01/10/2002, 01/10/2003.... like this

please help me

thanks
madhukar

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-01 : 11:35:23
without storing this info at that time you can't.
maybe if you have good database logs you could restore each year and see.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
   

- Advertisement -