locked
transactional replication issue RRS feed

  • Question

  • i took backup of the publisher database and restored it on subscriber successfully,transactional replication started.

    now, does the backup file need to be left on the disk,if yes then why?

     

    Wednesday, May 4, 2011 7:24 PM

Answers

  • now, does the backup file need to be left on the disk,if yes then why?

    No, the backup file does not need to be left on the disk.

    sqlrepl.com
    • Proposed as answer by Abhay_78 Thursday, May 5, 2011 4:00 PM
    • Marked as answer by Alex Feng (SQL) Thursday, May 12, 2011 3:24 AM
    Wednesday, May 4, 2011 9:30 PM
  • but for future if there is a need then again you will have to take the backup and restore that on the subscriber (since we choose this option because generating snapshot is costly) ..
    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    • Proposed as answer by Peja Tao Friday, May 6, 2011 6:07 AM
    • Marked as answer by Alex Feng (SQL) Thursday, May 12, 2011 3:24 AM
    Thursday, May 5, 2011 4:02 PM

All replies

  • If I understand you correctly then you have set up a transactional replication while initializing from backup and in this case the backup file at the sub is no longer in use at this point.

     


    -- Yaniv www.sqlserverutilities.com http://blogs.microsoft.co.il/blogs/yaniv_etrogi
    • Proposed as answer by Yaniv Etrogi Thursday, May 5, 2011 6:43 PM
    Wednesday, May 4, 2011 7:44 PM
  • No need once transactions being received by the subscriber.

     

    also make backup from initialization=false in publisher properties

    Wednesday, May 4, 2011 9:05 PM
  • now, does the backup file need to be left on the disk,if yes then why?

    No, the backup file does not need to be left on the disk.

    sqlrepl.com
    • Proposed as answer by Abhay_78 Thursday, May 5, 2011 4:00 PM
    • Marked as answer by Alex Feng (SQL) Thursday, May 12, 2011 3:24 AM
    Wednesday, May 4, 2011 9:30 PM
  • but for future if there is a need then again you will have to take the backup and restore that on the subscriber (since we choose this option because generating snapshot is costly) ..
    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    • Proposed as answer by Peja Tao Friday, May 6, 2011 6:07 AM
    • Marked as answer by Alex Feng (SQL) Thursday, May 12, 2011 3:24 AM
    Thursday, May 5, 2011 4:02 PM