How to truncate a log file

[dgillz]

I just ran a data conversion program which converted a database from Pervasive to MS SQL Server 2000. As a result I now have an .mdf and .ldf file, but the .df (log) file is huge, and I need to get rid of some records in it.

Can someone tell me how to do this?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[nigelrivett]

Make sure the database is in simple recovery mode or backup the log file then shrink the file.

You can do this vioa enterprise manager or dbcc shrinkfile.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.