|
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?
(comments are locked)
|
|
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
(comments are locked)
|
Your answer
