Seeder question: I have a file in a filegroup which was created in the wrong place, so I need to remove it and add it back in the right place. However, SQL Server tells me that I cannot remove the file because it has data in it. I cannot take the database off-line completely because it is in constant use. How do I go about removing and adding this file in the right place?
asked Oct 28 '09 at 09:56 AM in Default
Matt Whitfield ♦♦
You need to run
SQL will then prevent any more data being written to that file. You will then be able to use
Alternatively, you can do this from SSMS. This MSDN article takes you through the steps
answered Oct 28 '09 at 10:09 AM
Kev Riley ♦♦