I have a table called dbo.files which has a field filesize data type int.
I changed the data type to bigint and saved the table successfully.
Then I open the table and increased the filesize of one record from 30 to 21073535353.
It was fine...
Then I returned the value back to 30 and saved.
Now, I wanted to change the bigint to int.
I receive the error... 'files' table -Unable to modify table. The transaction log for database 'gprddevelopment' is full. To find out why space in th elog cannot be reused, see the log_reuse_wait_desc column in sys.databases
Your transaction is full.you need shrink it. Are you using transaction log backup? if not you can change it to simple recovery model so log doesn't grow huge.
Log File
Posted - 12/11/2012 : 12:27:52
