Logs/Restore Logs

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

From: Hassan (fatima_ja_at_hotmail.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 10:21:24 -0800

Whats contained the the Backup Log Files ? What goes on when a restore of
the log takes place on say a standby server ?

If I do some inserts/updates and deletes against DB A ... And when I backup
the log after executing those statements, will the log contain those DML
statements or will it contain all the data/index pages that were being
affected by those DML ?

And if it does contain the DML , does that mean that when a restore log
takes place, the DML gets fired on the standby ?
And if the backup logs do not contain DML statements, what would it contain
and how does it do the restore ?

Please let me know the technical details....Using SQL 2000.

Also curious to know what happens when some DBCC commands are run such as
dbreindex or indexdefrag ....

Relevant Pages

  • Re: Logs/Restore Logs
    ... The log files contain changes made to data in the database. ... depending on the DML. ... > Whats contained the the Backup Log Files? ... > And if it does contain the DML, does that mean that when a restore log ...
    (microsoft.public.sqlserver.server)
  • Re: Logs/Restore Logs
    ... How does the restore take place then? ... > depending on the DML. ... >> And if the backup logs do not contain DML statements, ...
    (microsoft.public.sqlserver.server)
  • Re: Log Shipping Problem
    ... Do you perform BACKUP LOG withinit OPTION and then RESTORE it. ... create database test ... backup database test to disk = 'd:\db.bak' WITH INIT ...
    (microsoft.public.sqlserver.server)
  • Logging shadow copy activity?
    ... A customer called today and said that some of their files mysteriously ... I checked the backup log and no ... one has done a restore. ... I have shadow copy enabled on the volume and I wonder ...
    (microsoft.public.windows.server.sbs)
  • How do I catalog a Tape HELP!!
    ... I have a probelm and need to Restore some files ... The Tape is NOT shown in backup log ... Tools only allow Catalog from FILE NAME and NOT Tape!! ...
    (microsoft.public.windows.server.sbs)