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