locked
Full & T-log RRS feed

  • Question

  • Hi Team,

    we planning to configure Logshipping on the Principal server from here to i have to take full & T-log backups, then i have to configure logshipping, it is correct or not.

    if any thing wrong please correct me.

    Tx


    subu

    Tuesday, July 24, 2012 8:05 AM

Answers

  • The simple answer is: If you have a full backup before you configure Logshipping you don't need to run one when you configure the secondary... The way is always the same: You need a full backup to initialize the secondary and all transaction log backups that have been taken between the full backup and the current state to initialize logshipping. How and when you take those backups + restores is pretty much up to you.
    • Marked as answer by Maggie Luo Tuesday, July 31, 2012 3:24 PM
    Wednesday, July 25, 2012 11:42 AM
  • Subu,


    Yes you are correct but please check below links as well for step by step tutorial with screenshots.

    Step By Step Guide to Configure the Log-Shipping On SQL Server

    Configuration Of Transaction Log shipping In SQL Server Step By Step



    Nareshkar Pakanati 

    MCTS, MCITP IT Specialist
    My Blog: www.mssqlfix.com
    Twitter: @mssqlfix
    -------------------------------------------------------
    Please mark the post as Answered if it answers your question.
    -------------------------------------------------------

    • Marked as answer by Maggie Luo Tuesday, July 31, 2012 3:24 PM
    Wednesday, July 25, 2012 12:59 PM

All replies

  • Subu,

    It is up to you, but its safe to have a full backup before configuring log shipping , actualy while you configure Secondary Database settings, there is an option to have a backup now  or use the existing backup.

    Here is the step by step instruction to configure log shipping http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, July 24, 2012 8:18 AM
  • Hi Team

    As per my knowledge we have to take ful &T-logs backups, before configuring logshipping, then only we have to configure logshipping.


    subu

    Tuesday, July 24, 2012 8:30 AM
  • HI Subbu,

    to configure log shipping we have to set database in FULL recovery mode, to check in which recovery mode database is run this query

    select name, recovery_model_desc from sys.databases

    check my blog for configuring log shipping in simple steps

    http://sqlservr.blog.com/2012/05/27/log-shipping-in-simple-steps/

    please check the requirements like

    both the SQL Servers should be started with the same domain name,

    databa must be in FULL Recovery model


    Ramesh Babu Vavilla MCTS,MSBI

    Tuesday, July 24, 2012 8:37 AM
  • Hi

    Which SQL Server version are you using? if it is 2005 or above I'll strongly suggest to use Database Mirroring for DR purposes

    http://msdn.microsoft.com/en-us/library/ms189852.aspx


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

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

    Tuesday, July 24, 2012 11:36 AM
  • The simple answer is: If you have a full backup before you configure Logshipping you don't need to run one when you configure the secondary... The way is always the same: You need a full backup to initialize the secondary and all transaction log backups that have been taken between the full backup and the current state to initialize logshipping. How and when you take those backups + restores is pretty much up to you.
    • Marked as answer by Maggie Luo Tuesday, July 31, 2012 3:24 PM
    Wednesday, July 25, 2012 11:42 AM
  • Subu,


    Yes you are correct but please check below links as well for step by step tutorial with screenshots.

    Step By Step Guide to Configure the Log-Shipping On SQL Server

    Configuration Of Transaction Log shipping In SQL Server Step By Step



    Nareshkar Pakanati 

    MCTS, MCITP IT Specialist
    My Blog: www.mssqlfix.com
    Twitter: @mssqlfix
    -------------------------------------------------------
    Please mark the post as Answered if it answers your question.
    -------------------------------------------------------

    • Marked as answer by Maggie Luo Tuesday, July 31, 2012 3:24 PM
    Wednesday, July 25, 2012 12:59 PM