Warning "THE TRANSACTION LOG FOR DATABASE 'X' IS FULL" in Plesk server

kumkumsharma

Administrator
Staff member
You will see this error while taking backup of MSSQL database with SQL Server Management Studio. The main reason for this error is that your transaction logs limit is reached which means disk space does not available space.
  • Connect your server with RDP.
  • Now start SQL server Management Studio and make connection with it.
  • Here you will find Databases option, you have to right click on it >> Tasks >> Back UP.
  • By default general page is selected, you have to choose Backup Type “Transaction log”.
  • Now you have to click on second page “Media Options”, you have to click on “Truncate transaction log” and then click on “Ok”.
 
Top