how to shrink the database

G

GG

Hi all,
I recently encounter the limited space issue. I found that the four
databases consuming quite huge hard disk space. Each database has two files.
The file with name like XXX_XXX_log.LDF is very big (up to 50G for publish
database). Does anyone know if it is normal? If there is a way to shrink it?
It looks like the log file.

Best Regards
Rock
 
R

Ray McCoppin

After you have completed a full backup of the database you need to truncate
and shrink the log files. I use the following comands to do that.

backup log pwa_draft with no_log
dbcc shrinkdatabase(pwa_draft,Truncateonly)

hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 Archive Tool
 
Top