Post reply

database was in stand by mode

  • July 17, 2012 at 5:39 am

    #264308

    HI team,

    We have 3 servers db01,db02,db03 01-02 we have configured mirroring

    02-03 configured logshipping in 03 server we have configured maintance plan full backup all databases

    but 03 all database was in stand by mode due to this reason every day maintance plan was failed

    Error: database was in stnad by mode for this reason, connectivity prob,parameter set correctly,Restult set property not set correctly.. any suggetions please help us.

    And give me one clarification we have configured DBMirroring and Logshipping. Again why we have to take every day full backup using maintaince paln this is correct or not

    as per my knowledge db was in stand by mode how can we take full bakup can you guys please suggest me in correct way.

    Tx

  • July 17, 2012 at 5:47 am

    #1513525

    You cannot take a backup of the standby databases, you will need to take the backup on the primary server.

    The only way to backup the DB's on 03 would be to restore with recovery then backup and reinitialise logshipping.

  • July 24, 2012 at 12:10 am

    #1516596

    Hi,

    Yes i agree with Anthony, you can't take the back of secondary server.

    1. You can take the back of Primary server because if you want to restore

    for test or else.

    2. You can't take the backup in secondary server because the DB is restoring

    condition.

    Satish

  • August 10, 2012 at 12:42 am

    #1524226

    Hi Shiva,

    Can you clarify my doubt..

    You mention in your comment 01 to 02 configure Mirroring & 02 to 03 configure Logshipping..... right

    02 server is mirroring with 01 server mean your Database is in restoring condition (can't read the data).

    I am not sure logshipping will configure with Mirror databases.

    Thanks

    Satish

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

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