locked
mirroring error RRS feed

  • Question

  • I am getting SQL Server Error 1475 
     
     The Error Message says : 
     
    Database mirroring cannot be enabled because the "Sales" database may have bulk logged changes that have not been backed up. The last log backup on the principal must be restored on the mirror.
     
     
     Any suggestions [ Solution | TIPS ]  to resolve [FIX] this ? 
     
      This is SQL Server Severity 16  Message 
     

    vivek

    Friday, June 22, 2012 11:55 AM

Answers

  • Hi,

    How are you trying to set-up mirroring?  Can you tell us the steps?

    You should be doing this:

    Perform a full back up the principal database

    Perform a transaction log backup of the principal database

    Copy both backup files over to your mirror server

    Restore the database from full backup file with no recovery

    Restore the transaction log with no recovery

    Go through the mirroring wizard, selecting the mode, etc. as per your requirements



    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

    • Marked as answer by Maggie Luo Sunday, July 1, 2012 4:08 PM
    Friday, June 22, 2012 12:54 PM

All replies

  • Hi,

    How are you trying to set-up mirroring?  Can you tell us the steps?

    You should be doing this:

    Perform a full back up the principal database

    Perform a transaction log backup of the principal database

    Copy both backup files over to your mirror server

    Restore the database from full backup file with no recovery

    Restore the transaction log with no recovery

    Go through the mirroring wizard, selecting the mode, etc. as per your requirements



    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

    • Marked as answer by Maggie Luo Sunday, July 1, 2012 4:08 PM
    Friday, June 22, 2012 12:54 PM
  • Also, what is your recovery model on the database? It needs to be Full in order to support Mirroring.
    Friday, June 22, 2012 3:11 PM
  • When you hit this, you can try:

    1. From pricipal database, backup transaction log
        BACKUP LOG Sales TO disk='c:\xxxxxx.trn'  

    2. Copy this file to database you want setup database mirror,

    3. Restore this transaction log backup 

        RESTORE LOG Sales from disk='xxxxxx.trn ' WITH NORECOVERY

    4. From Principle database
        Setup database mirroring again  and it should successful

    Monday, June 25, 2012 12:21 PM