Re: Database vs transaction logs

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



Your logs hold all transactions and commit them to the database and is
used soley for recovery purposes. If you loose your database; the
procedure would be to restore your database from backup then replay
the logs since the last backup of your database so that your database
is up to date. Say you brought up a brand new exchange server; and it
has been up for 3 days but you did not perform backup and lost
database but you still have logs. It is possible to recreate the
database from the logs and have it replayed.

However in a production environment; you would be using an exchange
aware backup solution that will be backing up your Exchange database;
logs and then purging the logs.

The article below gives good examples of how logs are used in the
recovery process.

How Exchange Online Backups Work in Exchange Server 2003
http://technet.microsoft.com/en-us/library/aa997186(EXCHG.65).aspx




James Chong (MVP)
MCITP | EMA; MCSE | M+, S+,
Security+, Project+, ITIL
msexchangetips.blogspot.com


On Aug 1, 7:21 am, "MSExchangeStudent"
<exchangestud...@xxxxxxxxxxxxxx> wrote:
Ok, please help me on this one - cant seem to find a good article that can
explain it.

I know the database contains your mail and if you have disaster recovery but
have a backup of your database you can restore. However i was told to have a
separate backup of my transaction logs also. In other words in case my
server crash and i loose my database that i have a copy of my transaction
logs at hand. Now my question is if i loose my database but have my
transaction logs would it mean something to me the fact that i have my logs.
Can i restore something or use it in some way?

Why is it neccessary to have logs and the database separate from each other?
If anyone has a good article or link also i can read up about it. Thanks in
advance

.



Relevant Pages

  • Re: Admin question about backups
    ... > that are up to 10 times as large as the database, ... > not truncating the transaction logs. ... > tape backup, how would you configure SQL Server 2000 to back up? ... Lets call this scenario 2. ...
    (microsoft.public.sqlserver)
  • Re: [fw-wiz] RE: IDS (was: FW appliance comparison)
    ... Logs compress really well, which further reduces your ... a SQL database with indexes on your tables and an interpreted ... > With that much data, and 98% of it being useless, you kind have ... >transaction - no, sorry, PACKET ...
    (Firewall-Wizards)
  • Re: Backups, Logs, Databases.. Logs written when? Serious Problem
    ... my concern is that my database spindles are on a raid 5 and I only have ... > 20 gig worth of transaction logs. ... > When I perform a full backup these logs need to get written to the databases ... If I run a full backup server will shut down? ...
    (microsoft.public.exchange.admin)
  • Re: Exchange realtime backup solution
    ... With typical Exchange-aware backup solutions you can restore up to point of failure. ... The whole transaction logging feature of Exchange database engine was created just for that - you have data in database and copy in transaction logs. ...
    (microsoft.public.exchange.admin)
  • Re: corrupt database eseutil
    ... I have checked the event logs, ... RSM was stopped at the time the backup fails. ... only after i run a successful backup that the database corrupts so it does ... a repair on the database. ...
    (microsoft.public.exchange.admin)