Solved

SQL Server

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Near realtime alert if SQL Server services stop. 20 73
Getting same value for every field in SQL 2 45
Sql Query with datetime 3 24
SQL Server 2012 r2 Make faster Temp Table 17 106
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 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