July 10, 2005 at 12:37 am
I run his (David Bird) script on on my backup server which works excellent. http://www.sqlservercentral.com/scripts/contributions/1533.asp
Before It was my log file size 10-GB after shirnks it's became 3.7-GB only.
I have one small question, is there any side effect on live database If I run on live server.
Is there any changes will accur in default log file size & settings...?
I mean, after run your script, I should able to take the backup & restore database & logs without any problems.
Thanks in advance for your valuable suggestions.
Best Regards
July 13, 2005 at 8:00 am
This was removed by the editor as SPAM
July 27, 2005 at 12:22 am
Technically and Conceptually, you should not see any issues (per my knowledge)
The only thing you might run into is, when you run a LOOONG DML statement, where LOG file needs to grow, that particular operation might glow SLOW (very first time) as it has to first grow the LOG file and then let the data sit on it.
Hope this helps.
paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply