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?