Solved

SQL Server

Posted on 2010-09-15
3
519 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
  • 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now