Re: Trimming HUGE Transaction Log

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

On Mon, 13 Oct 2008 12:49:01 -0700, Always OpenTo Suggestions wrote:

I deserve another DUH on that one. I typically backup the database and the
transaction log at the same time (in the same maintenance plan), so when I
say backup the database, I really mean both. I added differential backups
during the day, to increase the frequency of backups with minimal impact to
users on the system.

Hi Always Open To Suggestions,

You typically don't need to backup the database every time you backup
the log. Most installations use fairly frequent log backups (depending
on the load, sometimes up to a few per hour), and much less frequent
database backups.

I would only include differential backups in a backup plan in one of the
following cases:

a) Full backups have to be minimized because they slow down the system
in a 24x7 operation; high update frequency requires very frequent (e.g.
hourly) log backups; fast restore time required - in this case, weekly
full plus daily diff can mean the difference between restoring full,
diff, and maximum 24 log backups, or restoring full and maximum 168 (7
times 24!!) log backups

b) Not enough storage capacity for full backups onlyn

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: Database Size, Database Corruption, Message Store & Storage Group
    ... More careful monitoring of the server. ... Each extra storage group also requires more memory at startup, ... Also it is important to know if there was actually database corruption. ... In terms of backups, you should look at "how" you are performing backups. ...
    (microsoft.public.exchange.admin)
  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
    (microsoft.public.sqlserver.programming)
  • RE: Log Shipping and Full Backup Frequency. Advice?
    ... The transaction log is different; it is a recording of database actions. ... And, if you restore from any of these, you only get that state. ... This is not the case with the transaction log or its backups. ...
    (microsoft.public.sqlserver.server)
  • Re: Pervasive SQL 8.6
    ... and backups are done by copying the files off to tape - ... you'll want to have lots of memory on the server -- ... drives for the database files. ... set up your SAN with a configuration of 80% memory set ...
    (comp.databases.btrieve)
  • Re: Maintenance Recomendations -Compact?
    ... recs" you actually mean Maintenance Requirements, ... your database is still monolithic; ... That frequent Compact and Repair ... So, in addition to the above, take frequent backups of your ...
    (microsoft.public.access.gettingstarted)