Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Dump Transaction log

Posted on 1998-08-15
1
Medium Priority
?
1,257 Views
Last Modified: 2008-02-26
I am trying to export some tables from access into sqlserver 6.5,when i export using the odbc an error message comes up saying logsegment is full dump transaction log,how do i do that exactly and how do i give it more room,because i have alot of table to put in the sql server.
0
Comment
Question by:turbo1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
mvz121697 earned 300 total points
ID: 1089577
Log files are cleaned up when de database is backupped.
You can also delete the log-entry's yourself:
- Through SQL-Enterprise Manager, just double-click the database and there is a button 'Truncate log' or something.
- Or you can issue the 'DUMP TRANSACTION WITH TRUNCATE_ONLY' command

You can also make SQL-Server delete the log-entrys as soon as they are written to the database, by issuing the SQL-command:

EXEC sp_dboption databasename 'trunc. log on chpt.',true

If you do this and still get the error, then you have to make the expand the logspace of your database.
   
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question