Solved

SQL Server

Posted on 2010-09-15
3
524 Views
Last Modified: 2012-05-10
I'm trying to install an app with a SQL DB,

Error: Database Schema Creation Failed - The transaction log for database 'MYDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

That colum in sys.databases says "ACTIVE_TRANSACTION".  

How can I fix this?
0
Comment
Question by:saturation
[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
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Kamaraj Subramanian
ID: 33687907
Could be the database does not have AutoGrowth enabled. To enable autogrowth,

   1.
      From Microsft SQL Server Management Studio, right click on the database and select Properties
   2.
      On the left hand pane, click on Files
   3.
      Click on the AutoGrowth option button
   4.
      Check the "Enable Autogrowth" check box and set the File Growth size to a desired value
   5.
      Under "Maximum File Size", you might want to select the "Unrestricted File Growth" option

Hope this helps,
0
 
LVL 23

Accepted Solution

by:
Kamaraj Subramanian earned 500 total points
ID: 33687912
Try this too

Set the DB to simple recovery mode, like all the others, then do a once-off shrink of the log (just the log) if it's larger than it's supposed to be. Use DBCC ShrinkFile

You can shrink the log file there also. Right click the db, go to tasks, shrink, file and make sure you only shrink the log file. Shrinking any of the data files may reduce db performance.

If the user in question is db_owner, he can change the recovery mode via managment studio GUI, or query.
0
 

Author Comment

by:saturation
ID: 33687954
Unfortunately, I only have access to a query window from Mgmt Studio because it's hosted on a remote site.    I can run commands from a query window--how do I do that for any of those suggestions above?
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 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