Wednesday, September 14, 2011

How to delete database data file

1.DBCC SHRINKFILE('logical_file_name', EMPTYFILE).
2.After that, the file dropped with no problems.