SQL Server – DBCC COMMANDS (Information Statements)- DBCC OPENTRAN

DBCC OPENTRAN is used to identify the active transactions that may preventing the log truncation. DBCC OPENTRAN displays information about the oldest active transaction and oldest distributed and non distributed replicated transactions.




SQL Server – How to Start the SQL Server in Minimal Configuration GUI

To Start SQL Server in minimum configuration mode, we need to do the following.

Start-> All Programs -> SQL Server 2012 -> SQL Server Configuration Manager.

In Configuration manager window, we need to select corresponding SQL Server services, if multiple instances are there, Here SQL Server services

Right click on SQL Server services and choose properties -> Startup Parameters -> Add “-m” to the startup paramerters and Add it.

Please have a look at the below image.

Start SQL Server in Minimal Config Mode



In Minimal mode, SQL Server is started in Single User Mode.