Posted by Erland Sommarskog on 11/23/05 13:35

New MSSQL DBA (boscong88@gmail.com) writes:
> 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?

I don't know, but why not give it a try?

If this is a production machine, you may want to first play with a
test server, to see the effects of the commands.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Enterprise Manager - problem
• Prev in forum: Re: 100 % CPU Usage
• Thread view: Re: How to drop one of the tempdb files

[Reply to this message]