Welcome to the forums! [quote] Is there a built in tool to check the database health on SQL 2000? [/quote] AFAIK, no there is no built-in tool available; but you can have SQLCheck from Idera for free http://www.idera.com/Products/SQLcheck/Default.aspx ; although it will not give you all the information...

Hi, You have to analyse and foresee the growth of the database for the next 5 years (atleast) and based on that you have to keep hard disk space available for database. When you configure database growth option its always recommended that you set it for fix mb refer http://www.extremeexperts.com/SQL...