DBCC SHRINKFILE (
alter database test remove file
DBCC SHRINKFILE ('test1_log',EMPTYFILE)
alter database test remove file Test1_log
Note : The primary data file and log file cannot be removed.
I am an Ex-Sailor from Indian Navy who possesses rich experience in Microsoft SQL Server. I would take this opportunity to pay tribute to all those who serve their country with pride, always keeping “Service before Self”.