MSSQL Server Database’s Transaction Log Shrink
MSSQL Server Database’s Transaction Log Shrink For MSSQL DBA .Its very commo issue that transaction log locaation is about to full or completly fill.If the log fills while the database is online, the database remains online but can only be read, not updated. Which is for an OLTP DB is kind DB or application hung issue. In this blog ,We will discuss and show How you can resolve this issue. 1) Login to the system 2) Access “Microsoft SQL Server Management Studio” 3) Click on “Connect” Button. Now, you are now connected to the Database. 4) Expand “Databases” tree 5) Database’s Full & Transaction Logs backup before Shrink. a. Right Click on desired database b. Select “Task” ==> “Backup” ==>Choose “Backup type” as “Full” c. Enter Backup file Folder and File name with extension “.bak” d. Select “Task” ==> “Backup” ==> Choose “Backup type” as “Transaction Log” e. Enter Backup file Folder and File name w...