Managing MS SQL Server mdf files
Posted on 2006-05-15
I have a database that is currently using two data files and one log file. I need to be able to utilize 1 data file and 1 log file.
When I go to properties, and then choose Data Files I see that there are two seperate files in two different file groups. The structure currently looks like this:
space allocated 11 MB
File Group = PRIMARY
space allocated = 2000 MB
File Group = MISC_DATA
I'm relatively new to MS SQL. I'm currently under the belief that if I simply delete the MISC_DATA file and reallocate my space over to the PRIMARY data file, I will cause some problems. I'm also thinking that there may be a way in QA to run a sql script that would 'merge' this data into my PRIMARY file, re-size the space that's allocated and THEN it would be safe to remove the MISC_DATA.mdf. Any assistance consolidating these files is greatly appreciated !!!