Thanks Gail. I increased the frequency of logbackups.
I tried shrinking because, my log file size is 60 GB and a log backup releasing 90% of space.
that was my prod DB and my disk left with only 500 MB space left.
I thought of shrinking and release some gigs to OS to avoid any application interruption.
The problem now i am facing is, though i have 90% unused space in the log , i could not shrink it.Not sure why.
Please correct me if my approach is wrong.
Thanks for your time!
How big do the log files (the TRN files in the backups) end up being now that you're backing them up once per hour?
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs