k in simple words, what i required is :-

i need to deploy SSIS package of 2005 in sql server 2000. As far as i know, MS don't provide backward compatibility....

Total Size of disk is 34 GB & free space is 32 GB but the scenario is like this -

This drive has 3 disk each of more than 200...

Vishal,

That's the best practice.But in my scenario, it's not like that and even we can't do without appropriate permissions & all....Now what can be done to resolve that problem that...

Following are the details required by you:-

Database size - More than 200GB

Database recovery model - Simple

Freespace in database as well as on disk - Total Size of disk...

I think the SCOM tool from Microsoft can do centralised monitoring

GilaMonster said very correct that data file size grow is it's nature..Even if u try to shrink the file, it'll automatically grow..It can be useful in case of log file.....But...