Noam Graizer (7/15/2014)
I reset the services - not help.I can re-do this "alter database ...remove file" and this leaves the rows in the sys.database_files !!!
OOO !!!
I don't know what to do
What exactly are you trying to do?
Are you trying to remove a file for tempdb or for a user database?
For tempdb you'll need to take the instance down and perform the action so that tempdb is not in use. I would start the instance in single user\restricted mode and use the following
alter database tempdb remove file logicalname
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉