Database - free available space

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database - free available space

Author

Topic

MoniConc
Starting Member

3 Posts

Posted - 2008-02-13 : 11:18:41

Hi,

The properties of my database (right click on database in enterprise manager) show me that
- the volume (Größe) of my database is about 2700 MB,
- containing free space (Verfügbarer Speicherplatz) of about 2200 MB.

I want to free that available space as much as possible,
but I did'nt succeed in finding any function or setting to do that.

I need to get the volume down to remarkable smaller than 2000 MB.

Does anybody know how to do?

Thanks,
Monika.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-02-13 : 11:32:31

have you looked at DBCC SHRINKFILE ?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

MoniConc
Starting Member

3 Posts

Posted - 2008-02-14 : 03:41:19

Thank you Jack for your reply.

Yes, I did DBCC shrinkfile with the log-files and then
I did DBCC DBREINDEX and got a huge amount of free space
but WITHIN the database so that the volume was not reduced.

Then I did
DBCC shrinkdatabase without parameters and with parameters.

It did not work.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-16 : 00:55:17

Tried shrink db in enterprise manager?

MoniConc
Starting Member

3 Posts

Posted - 2008-02-21 : 10:17:44