I am getting this error.
Msg 9002, Level 17, State 4, Line 2
The transaction log for database 'SalesDWH' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
When I look at this column
log_reuse_wait_desc it just says
I use this code and got the error:
use SalesDWH go ALTER TABLE npidata ALTER COLUMN npi varchar(20)
I am just changing
NPI column from
The following code gives me the same error message:
insert into npidata1 select * from npidata
The recovery mode is
autogrowth is set to
autoshrink is set to
What else can I do?
To my understanding the logs should just be truncating every time they are getting too big.
What am I doing wrong?