Meditech NPR Reports / NPR Report Writing / NPR Report Writer / Meditech NPR / Non-Procedural Report / Meditech Consulting / Meditech Reports Relational Database Programming: Shrink SQL Server Databases

Saturday, March 25, 2006

Shrink SQL Server Databases

The following DBCC (Database Consistency Checker) command shrinks all database files to their minimum size.

/*
USE ADP1SQL
GO
DBCC SHRINKDATABASE (ADP1SQL,0,TRUNCATEONLY)
GO
*/

posted by olesharpie @ 1:25 PM   0 Comments

0 Comments:

Post a Comment

<< Home

Meditech NPR Reports / NPR Report Writing / NPR Report Writer / Meditech NPR / Non-Procedural Report / Meditech Consulting / Meditech Reports