Search code examples
sql-servertransaction-log

SQL Server full log issue -- how to update the database?

I am working with SQL Server 2000, and trying to change the data type of a field from varchar to nvarchar, so that it can handle international characters. However, there is already a lot of data in that table, and when I try to save the change, I get the following error:

Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'AppTest_Apps' is full. Back up the transaction log for the database to free up some log space.

This is a one-time update -- how do I get around the error?

Solution

  • You may need to allow the log file to grow larger (see the options on the log file), or backup and shrink it. http://support.microsoft.com/kb/272318