SQL Server Interview: If Transaction Log Full, what are your steps to resolve it

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

I am sharing one of the very common and important Interview Questions separately so that SQL Server DBAs can recognize very easily before going for SQL DBA Interview.

The question itself is one kind of common problem which is facing by many of SQL DBAs. When SQL Server transaction log full, they are getting an error like “SQL Server Error 9002 transaction log full”.

When an interviewer asks this question to you, you should give a very clear answer with a just list of few options. If they ask more, only you should explain in details; otherwise, it is OK.

Your answer should be like this,
If we got error 9002 transaction log full, we should take following points:

• We should take backup the transaction log file and truncate the transaction log
• We can move log file to another disk drive
• We can increase the size of log file
• We can also add a new transaction log file in separate disk

I am not sharing more details on each point. If you want, you should prepare it for yourself, but I would suggest avoiding detail answer because you need to prepare different commands for all the options.