asked on

Clearing Space Used By .LDF files

There is a data warehouse running on SQL Server 2000. During migration I see that Warehouse_Log.LDF has become 5+ GB in size. I did a checkpoint in Query Analyzer and shrank the database from the enterprise manager and yet this value does not go down in size.

What can I do to free up this space

Thanks

Shariq

Anthony Perkins

Please maintain your open questions:

1 04/23/2003 50 Output Table Data Into Fixed Length Form... Open 3rd Party Applications and Development Tools
2 09/09/2003 75 Convert From Oracle to MS-SQL Open Microsoft SQL Server

Thanks,
Anthony

ASKER CERTIFIED SOLUTION

kauf

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kauf

Ah yes, first - check that you've not checked automatically grow in the transaction log options to prevent even more size...

SOLUTION

htarlow

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kauf

in an emergency case, you can set a temporary (secondary) transaction log anytime (this you can delete after BACKUP LOG... w/o problems)

arbert

"in an emergency case, you can set a temporary (secondary) transaction log anytime (this you can delete after BACKUP LOG... w/o problems) "

why go through the extra effort. MS SQL Server best practices say that the log file should be set to auto grow....