Solved

DBCC SHRINKDATABASE

Posted on 2010-09-14
5
199 Views
Last Modified: 2013-12-01
How DBCC SHRINKDATABASE command works in sqlserver 2000?

Thanks,
Arun
0
Comment
Question by:arunbhatt
  • 2
5 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 33673941
Hi,
you can use
DBCC SHRINKDATABASE ( database_name [ ,target_percent ])
or use other optiong such as truncation

Read here about it http://msdn.microsoft.com/en-us/library/aa258287%28SQL.80%29.aspx

also there's

DBCC SHRINKFILE ({fileid | 'filename'}, [compress_size [, {NOTRUNCATE | TRUNCATEONLY | EMPTYFILE}]])

which the specified shrinks data files, I use it when i've small size DB.

Hope that helps

0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33678360
>>How DBCC SHRINKDATABASE command works in sqlserver 2000? <<
It shrinks the database.
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 33887023
Any luck? do you need additional info?
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39687903
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
t-sql Joining Issue 10 40
Query Optimization 14 44
This query failed in sql 2014 5 31
sql server computed columns 11 31
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question