MSSQL Server database Tranaction Log File full

[Former Member]

Dear all,

I am faceing a problem the Transaction log file PXILOG1.ldf has been full.Please help me for this

Thanks

Kumar

[Former Member · Accepted solution]

Hi Kumar,

Take a complete Offline backup of the database.it will free up the transaction log.

you can also set the recovery model of the database to SIMPLE.

Regards

Ram

[Former Member · Accepted solution]

Dear Ram,

I have taken offline backup and how i set the recovery model of database to SIMPLE.

Thanks

Kumar

[Former Member]

Hi Kumar,

Connect to your SQL Database,Select the database and right click on the database required and select properties.and in select Options tab and you can find recovery model there.select SIMPLE.

Hope this helps.

Regards

Ram