Shrink Database 1

[dbomrrsm]

I have a DB that has a log file that is 174 Mb in used space and 3GB of Free space.

I have backed up the database then shrunk it but the 3GB of free space remains and I cant get rid of it.

Any suggestions.

TIA

DBomrrsm

 

[nigelrivett]

see

http://www.nigelrivett.net/TransactionLogFileGrows_1.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Patrick2002]

Hi, just execute this in Query analyser :

backup log your_DB_Name with no_log
DBCC SHRINKDATABASE (N'your_DB_Name', 0,TRUNCATEONLY)

works like a charm for me ...