[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1259
  • Last Modified:

Dump Transaction log

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
turbo1
Asked:
turbo1
1 Solution
 
mvz121697Commented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now