SHRINK DATABASE IN SQL 6.5

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

--
30 Jun 2004 11:25 AM
Hi,

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.
P.
sql-tips
New Member
New Member

--
11 Aug 2004 06: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 http://docs.rinet.ru/MSSSSSSQL




Acceptable Use Policy
---