• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

SQL Server 2005 - Unable to modify table structure - Transaction log full???

Hi Experts,

I have a database hosted on Network Solutions. I am trying to add new columns to a really large table, but I am getting an error stating "unable to modify table - transaction log full...."

I ran "BACKUP LOG mydb WITH TRUNCATE ONLY" on the database using ms sql server 2005 express, but no luck....

Is there something I can do or try on my end using ms sql server express to fix this error, or does Network Solutions have to fix this on the database settings end?

Thanks in advance
  • 2
1 Solution
just make sure that you add a column with a default value (for example null)
otherwise, SQL Server might have to update that value to all existing records and that might cause you the log work
rmartesAuthor Commented:
I am doing that. I am trying to add a new column named Age - varchar(10) - default value null
Scott PletcherSenior DBACommented:
Are you adding the column using the gui "Design" view in SSMS, or by running an ALTER TABLE command?

The Design view adds huge overhead to making table changes.
rmartesAuthor Commented:
By GUI, I tried Alter column and it worked just fine. Thanks so much.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now