Friday, September 27, 2013

To consolidate database files:

DBCC SHRINKFILE('logicalFileName', EMPTYFILE);
ALTER DATABASE databaseName REMOVE FILE logicalFileName;

No comments:

Post a Comment