Solved

SQL Server

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 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