May 21, 2008 at 3:07 am
Hi Exports,
Here i am executing one stored procedure after execution that stored procedure is transaction log space released or not
any body give good suggestion in this issue plz
May 21, 2008 at 3:49 am
NO! a proc only influences the database.
Depending on the recovery model of that particular database, log file entries can be overwritten or not.
In normal situations, it is considered to be a bad practise to have auto shrink enabled for a production database.
So, the logfile(s) themself will not shrink.
If your db is in "simple recovery" mode, log entries will be overwritten after a commit or rollback of a transaction.
With the other recovery models, you'll need to perform a log backup to tell your db to overwrite the log entries.
Check books online for recovery models !!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply