Shrink data and log files to the last allocated extent
On 11 Apr, 2015
By : Charith Silva
No Comments
Views : 1920
DBCC SHRINKDATABASE command shrink all data and log files for a specific database. The TRUNCATEONLY option doesn’t do any compacting and just releases any free portion of the file to the OS. It doesn’t do the compacting because that’s what the option says – only truncate.
|
USE Master; GO DBCC SHRINKDATABASE (databasename, TRUNCATEONLY); |
Related
About The Author
Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development.
He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.
Number of Posts :
87
Leave a Comment