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