We have the SQL server 2005 where it has three data files on three different LUN's.
Each data file is 650 Gb but out of which data allocated is 325Gb and 325GB free space. So totally database size is 875GB but free space is approximately 900GB.
So please guide me whether i can go ahead to shrink the database files so that i can remove the free space on all database files.
else please guide me how can i remove free space on the database files.