> Hi all, I have a tempdb that consists of 8 datafiles, tempdb_data_1 to
> tempdb_data_8, each is 8GB. Now how can I drop 7 of them and leave
> only tempdb_data_1? Can this be done? Thanks a lot.

> 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?