cancel
Showing results for 
Search instead for 
Did you mean: 

How to backup the log file in SQL 2000 server.

Former Member
0 Kudos

Hi,

My server is ECC 6.0 on Nt 2003 with SQL 2000 server.

in log folder i have one file only. this size is increasing day by day. (up to 120 GB).

how to minimize this size. or i want remove this file ? (how to back up).

Regards,

swathi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Depending on your recovery model, you might be able to simply run this command to manually truncate the log:

BACKUP LOG <database name> WITH TRUNCATE_ONLY

This empties the log file but does not reduce its size. You will then want to use DBCC SHRINKFILE to reduce the size of the individual LDF file(s).

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

I do not thnk the Oracle</b> forum is thecorrect one to post a SQL Server question.

Why don´t post your question on the

Probably you will get an answer there.

Regards