DBCC SHRINKDATABASE

How DBCC SHRINKDATABASE command works in sqlserver 2000?

Thanks,
Arun
arunbhattAsked:
Who is Participating?
 
Jason Yousef, MSSr. BI  DeveloperCommented:
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
 
Anthony PerkinsCommented:
>>How DBCC SHRINKDATABASE command works in sqlserver 2000? <<
It shrinks the database.
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Any luck? do you need additional info?
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.