Keep in mind that with constantly shrinking and re-growing your log files,
you will get fragmentation at the disk level, in addition to the other
problems I mentioned. Check out the following:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp --
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
[quoted text, click to view] "Henrik" <henrik@arenblad.se> wrote in message
news:OiO9M5X5HHA.5360@TK2MSFTNGP03.phx.gbl...
hi tom,
Thanks for the BOL pointer.
Im currently logging the growth per week for my DBs so I can see the
individual need for them. Loggfiles included.
My priority was to shrink them because of diskspace problems.
After that I need this info for a long term maint plan.
Thanks
Regards
Henrik
[quoted text, click to view] "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:OWm4zvX5HHA.600@TK2MSFTNGP05.phx.gbl...
> Check out DBCC SHRINKFILE in the BOL. However, your log files have grown
> to
> that size for a reason. If they needed the space before, they probably
> will
> need it in the future, at which point you won't be able to modify data
> until
> the log file autogrows.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
>
https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Henrik" <henrik@arenblad.se> wrote in message
> news:%230TvgeW5HHA.484@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> Im new at SQL and have a question.
>
> I need help with a query command that can shrink log files for several DBs
> when running this query.
>
> Greatfull for help.
>
> Regards
> Henrik
>
>
