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?
Posted
Comments
Michael_Davies 1-Apr-15 2:51am
   
Google shows: http://stackoverflow.com/questions/13975905/potential-causes-and-solutions-for-the-transaction-log-in-database-being-full

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.
   
Comments
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