• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

Log file is full ?

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 ?
0
team2005
Asked:
team2005
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
 
team2005Author Commented:
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 ?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
change the recovery mode of the db to SIMPLE:
http://msdn.microsoft.com/en-us/library/ms189275.aspx
after that, perform a full backup, and the error should be gone
0
 
EvilPostItCommented:
Change the database recovery mode to simple.

ALTER DATABASE [DATABASENAME] SET RECOVERY SIMPLE

Open in new window

0
 
team2005Author Commented:
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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