Post reply

Primary Node MSDb is not updatinng

  • June 15, 2016 at 9:34 pm

    #308528

    Hi All,

    In our environment we have a cluster setup and always on and we are performing Copy only backup in node 2 and similarly we have backup setup in Node1 As well.

    When ever we want to know the latest backup details it was showing only Node2 details. In general MSDB is common for all the databases configured for Always on. Please advise.

    Also is it possible to restore copy only backup followed by Tlog.

  • June 16, 2016 at 1:37 pm

    #1885492

    New persopn (6/15/2016)

    Hi All,

    In our environment we have a cluster setup and always on and we are performing Copy only backup in node 2 and similarly we have backup setup in Node1 As well.

    When ever we want to know the latest backup details it was showing only Node2 details. In general MSDB is common for all the databases configured for Always on. Please advise.

    Also is it possible to restore copy only backup followed by Tlog.

    By any chance, is MSDB on one of "local" drives on each node? For example, is the .MDF file for MSDB on the C: drive?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 17, 2016 at 2:09 am

    #1885549

    Yes, All the installation files are available in C drive only. if it is in C drive why it won't reflect any specific reason

Viewing 3 posts - 1 through 2 (of 2 total)

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