Click here to Skip to main content
15,064,915 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi everyone,

I have a table for transaction log which have millions of data, now i need to create multiple indexes on the table for faster query processing.

When i'm creating index using CREATE NONCLUSTERED INDEX syntax, it throws following error.

Msg 9002, Level 17, State 2, Line 1
The transaction log for database 'dbName' is full due to 'LOG_BACKUP'.

Can any one suggest how to overcome this situation?
Michael_Davies 1-Apr-15 2:51am
Google shows:

1 solution

I think you need to change the recovery mode to SIMPLE recovery mode or take the backup of log file and try again.
Hetal Jariwala 1-Apr-15 4:43am
Okay let me try
Hetal Jariwala 1-Apr-15 7:35am
After setting recovery modde to simple solves my problem
Code For You 2-Apr-15 1:38am
:) good work thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900