Monday, March 12, 2012

how to get rid of free db spaces on sql sever 7

I have a SQL Server 7 and after I shrank one of the databases, I got 14 gb of
free spaces. How to get rid of the extra free spaces on Version 7 of SQL
Server environment?
DBCC SHRINKDATABASE or DBCC SHRINKFILE
With version 7.0, however, you will have a heck of a time shrinking the log
file. If you can not get it to shrink as far as you would like, detach the
database, then move the log file somewhere else, and use the
sp_attach_single_file_db. This should regenerate a new log file, but using
the model database as a template instead of the old one.
Sincerely,
Anthony Thomas
"GR" wrote:

> I have a SQL Server 7 and after I shrank one of the databases, I got 14 gb of
> free spaces. How to get rid of the extra free spaces on Version 7 of SQL
> Server environment?
>

No comments:

Post a Comment