|
|
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?
Navigation:
[Reply to this message]
|