Post reply

Logshipping

  • June 7, 2011 at 10:29 pm

    #241826

    Comments posted to this topic are about the item Logshipping

    Thanks

  • June 8, 2011 at 1:56 am

    #1335477

    Thank you for the question, good one.

    M&M

  • June 8, 2011 at 5:14 am

    #1335539

    Yes, but you must log ship to a different database name

    Is this correct?

    I think Logshipping needs two instances.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 8, 2011 at 5:17 am

    #1335541

    Very interesting :w00t:; especially since BOL describes this feature in a way that one may assume it is not possible.

    The clue is--and I would say hidden--in this article, where it states:

    The log shipping secondary databases should be on different server instances than either the principal/primary server or mirror/primary server.

    Thanks for the lesson,

    Michael

  • June 8, 2011 at 6:05 am

    #1335570

    is it really functional?

    but, the MSDN say different: http://msdn.microsoft.com/en-us/library/ms187103.aspx, directly on first paragraph!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • June 8, 2011 at 6:11 am

    #1335575

    u can Check it

    Thanks

  • June 8, 2011 at 6:37 am

    #1335592

    forsqlserver (6/8/2011)

    u can Check it

    Can you give me the reference.Where you got it.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 8, 2011 at 6:40 am

    #1335594

    Is BOL scrappy?

    Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.

  • June 8, 2011 at 6:41 am

    #1335598

    I have tested it on test PC.

    Thanks

  • June 8, 2011 at 6:57 am

    #1335615

    forsqlserver

    i'm sorry, but you are correct!!! i finished the test for log shipping!!! it's really works in same instance with differents databases!

    Thanks!! it's a very good question!!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • June 8, 2011 at 7:01 am

    #1335619

    but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!

    😀

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • June 8, 2011 at 7:04 am

    #1335622

    The "correct" answer seems to contradict the question.

  • June 8, 2011 at 7:13 am

    #1335631

    It seems at first that this would be counter-productive, it could be log-shipped to separate disk, yes? You'd still have some shared resources (uh, the instance), but maybe it's a poor man's disaster recovery... 🙂 ?

  • June 8, 2011 at 7:17 am

    #1335635

    But u can use the secondary database as reporting database.

    Thanks

  • June 8, 2011 at 7:19 am

    #1335640

    forsqlserver (6/8/2011)

    But u can use the secondary database as reporting database.

    and have SSRS on same instance of DB???

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

Viewing 15 posts - 1 through 15 (of 47 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy