SQL 2000 and shrink large database don't reduce log file size
Posted on 2009-07-03
Hi to all,
I have one of my SQL Server (2000, Standard) that log file has growth drammatically and disk space is going to out.
Total size db is 50GB and log file is 44GB. Disk space available is 12GB.
I've tried to perform shrink, that in the past was ran successfully, but since two days when
try to shrink (from enterprise manager), operation is done with success but the log file still at the same size.
I would like to try this statement:
BACKUP LOG <databasename> WITH NO_LOG to empty log file and then proceed again with shrink but I'm worry about poor disk space available. The above statement will consume additional space and is it possible estimates time for execution ?
The server is in production h24 with high utilization.
Thanks in advance.