Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
In my visual basic application I am using "dump transactoin <database-name> with no_log". While running I am getting error on this line. This line necessary in this project and I wont remove it. How to solve this error in this project and what is the use of this line. Kindly help me.

What I have tried:

Searched in google and cannot find the solution.
Posted
Updated 19-Jul-20 20:15pm
Comments
Garth J Lancaster 20-Jul-20 1:14am    
Maybe you should use Improve question to add the relevant code, the error text itself, and what 'type' of database you're using - I'd have to guess at MS SQL Server

As it stands, the only information I can offer, assuming you're using SQL server, is that the transaction log records all database modifications and transactions, but will fill up if it is not managed. This transaction log can be used to repair a 'corrupt' database. Where I worked recently we needed to manage transaction logs for databases we received from clients before we could load the database for analysis
Patrice T 20-Jul-20 2:12am    
We are out of mind reading potion.

1 solution

You need to spell it correctly:
dump transactoin <database-name> with no_log
             ^^
Becomes
dump transaction <database-name> with no_log
             ^^
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900