<div>
to solve:<br />
do a full backup of the database<br />
implement a regular full AND a even more regular transaction log backups.<br />
<br />
if you would not care about being able to recover to a point in time, and you would be happy with only full backups, you also could change your database to be indeed overwrite the transaction log file contents as it goes.
</div>


to solve:
do a full backup of the database
implement a regular full AND a even more regular transaction log backups.

if you would not care about being able to recover to a point in time, and you would be happy with only full backups, you also could change your database to be indeed overwrite the transaction log file contents as it goes.

<div>
Hi!<br />
<br />
How do i remove this error ?<br />
<br />
if you would not care about being able to recover to a point in time, and you would be happy with only full backups, you also could change your database to be indeed overwrite the transaction log file contents as it goes. <br />
<br />
HOW ?
</div>


Hi!

How do i remove this error ?

if you would not care about being able to recover to a point in time, and you would be happy with only full backups, you also could change your database to be indeed overwrite the transaction log file contents as it goes.

HOW ?

<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
When i call a stored procedure, that import a txtfile i get this error message:<br />
[Error Code: 9002, SQL State: S1000] &nbsp;The transaction log for database 'Vectura' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases<br />
<br />
How can i solve this ?
</div>
</div>


Hi!

When i call a stored procedure, that import a txtfile i get this error message:
[Error Code: 9002, SQL State: S1000]  The transaction log for database 'Vectura' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

How can i solve this ?

Log file is full ?

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.