Posted by New MSSQL DBA on 11/23/05 10:34

I've tried this:

use tempdb
go
dbcc shrinkfile(tempdev4, emptyfile)
go
alter database tempdb
remove file tempdev4
go


then it gives something like this:

Server: Msg 5042, Level 16, State 1, Line 1
The file 'tempdev4' cannot be removed because it is not empty.
File 'E:\Microsoft SQL Server\MSSQL\data\tempdev4.ndf' modified in
sysaltfiles. Delete old file after restarting SQL Server.


Don't know what does this mean. Does it mean that the file will be
dropped after I restarted the server?

[Back to original message]