I have added ndf to tempdb for checking performance improvement....
Now i want to remove the ndf file... I am using below command...
DBCC SHRINKFILE (3, TRUNCATEONLY);
ALTER DATABASE TEMPDB Remove FILE tempdev1
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
2 3 7664 7664 32 32
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 5042, Level 16, State 1, Line 1
The file 'tempdev1' cannot be removed because it is not empty.
=>I restarted SQLServer from SSMS and then ran same commands mentioned above ,......and getting same error...
=> I executed above commands and restarted services...no change...
Can any one please help me to remove / drop ndf file...