Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server

Posted on 2010-09-15
3
Medium Priority
?
526 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

604 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