I am trying to increase size of a few columns in a very large table (from numeric(7,2) to (11,6)). After the "alter table <my table>" command ran for 1:30 hours I got the following error message:
"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"
What should I do to resolve the issue? Thanks.