471,049 Members | 1,423 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

SQL Server 2000 and Transaction Log Error

Hi All:

I am getting an error when trying to open a recordset in SQL Server 2000.
The error states that the transaction log is full. Is there any way I can
clear out or empty the transaction log, or get rid of it alltogether as it
is not really needed?

Any help would be appreciated.

Thanks and regards,

Jul 20 '05 #1
1 2705
First you can run

backup log dbname with truncate_only

then you can run

DBCC SHRINKFILE (logfilename, 5) (shrinks log file to 5mb)

then change the recovery mode to simple

alter database dbname set recovery simple



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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Hasan | last post: by
2 posts views Thread by Elvira Zeinalova | last post: by
1 post views Thread by Janez Kostanj¹ek | last post: by
9 posts views Thread by dotnetfellow | last post: by
10 posts views Thread by sara | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.