Applying Transaction Log Backups, Help please !! 
Author Message
 Applying Transaction Log Backups, Help please !!

Hi,

I have applying transaction log backups in a database with File=x and
Standby options.
Example:

   RESTORE LOG COMERCIAL
    FROM  DMPComercialLog991115
    WITH FILE=1,
    STANDBY = 'E:\DAT\COMERCIALLOG_UNDO.LDF'

   where:
              FILE=1   - Is the sequence from backup logs named
DMPComercialLog991115.

              STANDBY = 'E:\DAT\COMERCIALLOG_UNDO.LDF'  is the UNDO file

  When i am aplying transaction logs and for mistake  reaplying the same
transaction log backup, not message return with error.  the question is:  Is
the database in  consistent state after this?

Thank you in Advance
Alonso Duarte



Fri, 17 May 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Server 7.0, Cold Backup and Applying Transaction Logs

2. Applying Transaction Log Backups !!!

3. Please help...Backup vs Transaction log vs Restore is so important

4. Please help...Backup vs Transaction log vs Restore is so important

5. Transaction Log backup Error. Please help

6. Transaction Log backup help please.

7. Transaction logs and backup logs

8. Question about Transaction log backup with Backup Exec

9. Transaction Log Backups Are Slower When The First Portion Of The Log Sequence Number Increments

10. Does log backup truncate transaction log?

11. Backup from filegroup without transaction log backups

12. SQL DB Backup - transaction log backup?


 
Powered by phpBB® Forum Software