This may be a quick and easy one.
I have a SQL2000 database that is split into two data files and the logfile. The 2 data files are in the same filegroup and they both are only using about a 5th of the space allocated to them meaning a problem with server space.
What is the quickest and easiest method of converting this database to one data file plus release all the unused space? Not only am I a Forum nub but am pretty new to SQL also.
Many thanks 🙂