SQL Server 2K BackUp

[Danilo Popoviæ]

Hi everybody,

I have SQL Server 2K database with 114 MB of data and 220 MB of log file. I
have 213 MB of log file free ana stil I cannot shrink log file to 30 MB!
Where is the problem?

Thank you in advance

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
Croatia

[Ray Higdon]

Re: SQL Server 2K BackUp

If the free space is there try using dbcc shrinkfile, have you tried
this already and it did not work?

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Danilo Popovic]

Re: SQL Server 2K BackUp

Hi, Ray

Dbcc shrinkfile (is_log, 10) changed is_log's file size from 220 MB to 162
MB!!!
This is a message from SQLSvr:

Cannot shrink log file 2 (IS_Log) because all logical log files are in use.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
8 2 20632 3185 20632 3184

(1 row(s) affected)

I tried with truncateonly option and notihing happened. :-/

[Ray Higdon]

Re: SQL Server 2K BackUp

Try these:

http://www.support.microsoft.com/?id=272318

http://www.support.microsoft.com/?id=110139

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Danilo Popovic]

Re: SQL Server 2K BackUp

Thank you. That works!