Re: Shrink Transaction Log

Tech-Archive recommends: Fix windows errors by optimizing your registry

Here are the instructions the guy gave me:

Database is in full recovery mode.

He instructed to change it from full to simple. Then to do tasks, shrink,
files, change file type to "log" and then push ok.

Then he said to change the recovery mode back to full.

If understand this correctly, I can leave it in full recovery mode and set
up a schedule to back up the transaction log which will empty out the log
when it does this; or; I can just leave it in simple at which time it will
overwrite itself and I won't ever have to "shrink" with either method?

gmc


.

Relevant Pages

  • Re: XP Problem, Please Help--
    ... jamalsbro wrote: ... windows could not start because the following file is missing or ... I found some instructions on how to fix ... in recovery mode which I did, however, when I was copying the files ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Recovered mailbox still causes "Exchange is in recovery mode" messages?
    ... he got a warning message something to the ... "Exchange is in recovery mode." ... with instructions to press OK ... that Exchange will get OUT of this mode? ...
    (microsoft.public.exchange.admin)
  • Re: SQL 2005 Shrink issue
    ... If you are in full recovery mode, ... doing regular log transaction backups. ... transaction log file, and you should be able to shrink. ...
    (microsoft.public.sqlserver.tools)
  • Re: LOG files
    ... You might also move to Simple recovery mode, then later shrink the database ... Wayne Snyder, MCDBA, SQL Server MVP ... > bigger than the data files themselves. ...
    (microsoft.public.sqlserver.programming)
  • tempdb.mdf & tempdb.ldf
    ... i am using sql server 7.0 and i realised that both the ... is it due to the fact that the recovery mode is "Simple"? ... log after the bkup is completed or i'll do it via an "auto ... shrink" in the db's option or thru the DBCC ...
    (microsoft.public.sqlserver.server)