Last Post 11 Aug 2004 05:52 AM by sql-tips. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

30 Jun 2004 10:25 AM

Does anyone know how to shrink a database in SQL 6.5?

The databses (device) has 4 gb, but is empty.
I don't want to delete the database. Just to release the space.
DBCC shrinkdb is not working.
GUI method also not.

Thx for any idea.
New Member
New Member

11 Aug 2004 05:52 AM
SQL Enterprise Manager provides an option to shrink a database. This is done by internally calling DBCC SHRINKDB. Note that the SQL Server must be started in single-user mode to perform these operations.
If it's not started in single-user mode, there will be users, system handles such as the CHECKPOINT and MIRROR handlers, that can't be removed from the database and, therefore, prevent the operation from succeeding.

To start SQL Server in single-user mode use the -m keyword and start SQL Server from the command-line.

Check for more info

Acceptable Use Policy