June 12, 2009 at 1:41 am
how can we check the file growth of a database
June 12, 2009 at 2:06 am
Which version of SQL are you using?
In 2005 there are some standard reports via SSMS. Right Click DB | Reports | Standard Reports.
JL
June 12, 2009 at 3:11 am
both 2000 and 2005 servers...can u give me idea how to generate that report
June 12, 2009 at 4:26 am
In 2005 there are some standard reports via SSMS. Right Click DB | Reports | Standard Reports.
To get these report you need to install SQLServer2005_PerformanceDashboard.msi by running setup. This is a built in tool which ship with your SQL server binaries. The standard report will give you mainly Disk, Table and Index usages.
Or you can check the database properties select the to find the value it is set. To get a Report you need to have a script which will monitor the DB growth. All these scripts are available under SCRIPT section of this forum.
"More Green More Oxygen !! Plant a tree today"
June 12, 2009 at 5:13 am
wat about 2000 servers
June 12, 2009 at 5:33 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply