DB standby mode

Question

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

---

subu

Answer 1

Hi!

In a mirroring configuration (assuming REAL Mirroring, not SQL 2012 AlwaysOn AG) you need to do a full backup from the Primary of the mirroring only. None of the other servers will support backup. Only SQL 2012 Always On Availability Groups support backups from the secondary DBs.

To answer the question before you ask: Why don't you need a backup from the logshipper? Because it is a copy of the primary. If you need to restore the logshipper you do it with the last backup from the primary.

Hope that helps

Lucifer

Answer 2

Hi Prince,

Thanks for your reply..

we are using sql server 2008 R2. As per my understanding in 03 database was in standby mode how can we take full backup using Maintaince plan

it is not correct to recommand. But SYSTEM database we will take backup i think it will work

But database was in Standby mode its not possible to take full backup.

Is there any way please suggest me because my maintance paln step2 backups job was failed.

Tx

---

subu

Answer 3

to implement Database mirroring ,mirrored databases must be in no recovery mode

not in stand by mode,

in standby mode database will be able to be accesed as readonly databases,i

in norecovery mode database will not be able to access

to change the databases from standby to norecovery mode run this

restore database dbname with norecovery

---

Ramesh Babu Vavilla MCTS,MSBI