The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads
SQL Server Universe.com » Miscellaneous » Articles at SQL Server Univers... » Log Shipping with SQL Server 2005

Log Shipping with SQL Server 2005

Last post 06-03-2008, 15:44 by Dinesh Priyankara. 4 replies.
Sort Posts: Previous

  • Star [*] Log Shipping with SQL Server 2005

    		 11-13-2007, 13:20

    Dinesh Priyankara
    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote
    Log shipping has been a mechanism for maintaining a warm standby server for years. This article explains how to implement log shipping with SQL Server 2005. Read and see how useful it is.

    How would you rate this?

    • Excellent (50%)
    • Good (50%)
    • Average (0%)
    • Fair (0%)
    • Poor (0%)
    • Total Votes: 4

  • Re: Log Shipping with SQL Server 2005

    		 12-14-2007, 2:43

    Reddy
    • Joined on 12-13-2007
    • Posts 1
    • Points 0
    • Top 75 Contributor
    Reply Quote

    Hi,

    This is really a good and helpfull article. Its also more helpfull if add some realtime issues/troublshooting while implementing and monitoring/Failover  Log Shipping. Hope you consider this and out some usefull information.s

    Thanks
    Reddy

  • Re: Log Shipping with SQL Server 2005

    		 12-14-2007, 8:58

    Dinesh Priyankara
    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote

    Hi Reddy,

    Thanks for the comment. I may be adding more info to this article (because I will be doing some projects related to this soon) including the issues/solutions.

    Thanks
     

  • Re: Log Shipping with SQL Server 2005

    		 06-03-2008, 13:13

    nageswarv
    • Joined on 06-02-2008
    • Posts 2
    • Points 0
    • Top 75 Contributor
    Reply Quote

    Hi,

    This is really a good and helpfull article. Its also more helpfull if add some realtime issues/troublshooting while implementing and monitoring/Failover  Log Shipping. ok, but how to change again "stanby to Norml Live Data base"  ..... in this there is no data .. so can you help me .....

    Thanks
    Nageswar

  • Re: Log Shipping with SQL Server 2005

    		 06-03-2008, 15:44

    Dinesh Priyankara
    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote
    Hi Nageswar,

    There is no different, just execute the RESTORE LOG {database} WITH RECOVERY. If you have any transactions need to be backed up before bring the standby server online, make sure you apply them to standby server before executing the statement.
View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)
Powered by Community Server, by Telligent Systems