Home > Uncategorized > Shrink Sql Server database files

Shrink Sql Server database files

This is the query to dynamically generate scripts to shrink sql server data files by keeping 20% space from free space.

SELECT ‘DBCC SHRINKFILE ( ”’, name , ””, ‘,’,

CAST(CAST(size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 as INT)*.20 as INT)

, ‘);’

FROM sys.database_files;

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: