2012년 7월 17일 화요일 오전 11:27
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.
- 편집됨 subu999 2012년 7월 17일 화요일 오전 11:32
2012년 7월 17일 화요일 오후 12:05
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
2012년 7월 17일 화요일 오후 12:27
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.
2012년 7월 17일 화요일 오후 1:35
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