Hello,

Database log file on MSsql2000sp3 is 27gb when database itsself 305mb.
I attempted to shrink the log file with Enterprise manager,but it wants
to use a minimum of 26.xxx MB,approximatley 27gb of disk space.
when running the dbcc shrinkfile (file_name) message returned is "all
virtual logs are in use'
Any ideas how to reduce the log file?

Thanks in advance



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

ilias Mintidis <imintidi@sebh.org> wrote in message news:<3f9d51af$0$194$75868355@news.frii.net>...
> Hello,
>
> Database log file on MSsql2000sp3 is 27gb when database itsself 305mb.
> I attempted to shrink the log file with Enterprise manager,but it wants
> to use a minimum of 26.xxx MB,approximatley 27gb of disk space.
> when running the dbcc shrinkfile (file_name) message returned is "all
> virtual logs are in use'
> Any ideas how to reduce the log file?
>
> Thanks in advance
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

http://support.microsoft.com/default...b;EN-US;272318

Simon

Thanks

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