Thank you Steve for trying to help me. This is a Named SQL instance configured with port 1433 which sits on 2 node cluster. And we don't want to touch...

Thank you rajborntodare

Thank you all! Will see next week which solution will work.

GilaMonster, You heard me right. I will bring the secondary databases for testing the apps in DR environment, meanwhile primary databases will continue running in real production. Then after the...

The DR is stand alone server

Thanks a lot!

Thank you. I've changed it to SQLCMD and even found a new option -W to make the output to look better

Thank you Jeff, this is exactly what I needed. It worked just fine. Unfortunately I can not use SSIS because the scripts should reside off the SQL server.

Thanks everyone for your help.

After adjusting transaction log backup frequency transaction logs size is finally under control.

Mike,

Thank you for the advice, I will change trans log bkp to 15 min instead of 2 hours.

Please clarify for me: In order to have a trans log file...

I know this option and I do it sometimes, but there is a common opinion that we shouldn't shrink our logs too often since it fragments the file. So, are...

Thank you for the tip!

Thank you for your help!

Thank you Li Zhi-song for your help. It did work and solved my problem.

Thank you Nitin!

It worked!