having difficulty in SP or query to carry out this operation.

Actual size of the .mdf file is around 84.5GB, Database size is around 86.8GB and the total size of the drive is 136GB. does shriking the mdf file help in...

So should the file growth be set to "By 10 or 20MB unrestricted" ?.. and also is there a way to clean up the drive were the .mdf file resides...

the file growth of the database file has been 'Unrestrictedgrowth, By 1MB' and recoevery model is 'Simple'. has this anything to do with the service pack installed or something else?

All these have been already installed in the server...is there anything else to resolve this issue?