Re: archive logging the log file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/03/04 

Date: Thu, 2 Dec 2004 23:00:47 -0600

I believe you are referring to transaction logs. The proper way to manage
transaction logs for databases in the FULL or BULK_LOGGED recovery model is
to backup the transaction log periodically. This will remove committed data
from the log (keeping the size reasonable) and allow you to use the log
backups in conjunction with database backups as part of your recovery plan.

A common practice is to backup to disk and then archive those backups to
tape. You can setup database maintenance plans to perform both database and
transaction log backups or create and schedule your own backup scripts. See
the Books Online for more information. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"learningdba" <learningdba@discussions.microsoft.com> wrote in message 
news:6BAE1103-01FC-45A4-B57E-B8FCD9AA86E3@microsoft.com...
>I am new to SQL Server, but I cannot seem to find any way that SQL Server
> will automatically move a log file (when it isn't needed anymore) off to
> archive. Is the only way I can do this by setting up a batch process and
> doing it myself?
>
> Help?

Relevant Pages

  • Re: Full vs Simple Recovery Mode
    ... Once you setup your transaction log backups - and back up your transaction logs on a frequent basis, the log file will settle at the largest size it needs to be in that hour time frame. ... night, or for small DBs, I can take multiple full backups during the day. ... In fact, the recovery model was introduced to do just that: make the backup-option setting not affect application code. ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction logs getting too large
    ... If you don't care about transaction logs you can set the recovery model to simple ... ALTER DATABASE YourDatabase SET RECOVERY SIMPLE ... You will probably need to shrink the log file after setting the recovery model to simple. ...
    (microsoft.public.sqlserver.server)
  • Re: Full vs Simple Recovery Mode
    ... don't reliably expire previous backups, so they accumulate on the volume ... Backup Exec to recover databases. ... issues you are having managing transaction logs. ... night, or for small DBs, I can take multiple full backups during the day. ...
    (microsoft.public.sqlserver.server)
  • Re: huge exchange logs
    ... to delete them or is there any guide/insturction to properly change ... These are your transaction logs. ... need their add-on Exchange agent to permit an online backup of Exchange. ... I agree as well with you and Merv that Full SUCCESSFUL backups will purge ...
    (microsoft.public.windows.server.sbs)
  • Re: Transaction log ???
    ... I don't really understand your first question, but the log is there to ... then the simplest option may be to set your database to ... the simple recovery model - the log will then be truncated ...
    (comp.databases.ms-sqlserver)