How to run a DB shrink

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / General / SQL Server Tools / March 2008

How to run a DB shrink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LMI - 13 Mar 2008 12:31 GMT

Can anyone help me with how to run a DB shrink? How do I do it where do I run
it?

Reply to this Message

Russell Fields - 13 Mar 2008 14:18 GMT

LMI,

In the SQL Server Books Online, read the following topics:
DBCC SHRINKDB
DBCC SHRINKFILE

Also read http://www.karaszi.com/SQLServer/info_dont_shrink.asp . Tibor
gives good advice, which (despite the title) includes dicussing how to
shrink when you need to.

RLF

> Can anyone help me with how to run a DB shrink? How do I do it where do I
> run
> it?

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.