sql server mseq: Hi,

I am in EM and SQL 2000 on w2k sp3. I shrink the log
files and then shrink the database but my disk size is
not decreasing. Can some please explain to me how to free
up disk space when truncating the logs.
Any help would be greatly appreciated as I am a newbie.

Thanking You

Worth reading following articles

http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL Server 7.0 Tran Lo
http://www.support.microsoft.com/?id=317375 Log File Grows too bi
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink Fil
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow and AutoShrin
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQLServer 2000 with DBCC SHRINKFIL
http://www.support.microsoft.com/?id=317375 Log File Grows too bi
http://www.support.microsoft.com/?id=110139 Log file filling u
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink Fil
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow and AutoShrin

try this,

use name
backup log name with truncate_only
go
dbcc shrinkfile(LogFile,size)
go


[quoted text, click to view]