Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-30 : 08:33:43
|
| Hello, I have 2 questions regarding DB mirroring:1. If I am not using Witness Server and the primary database server goes down, then how can I failover to the secondary database? This is because the 'failover' button has to be clicked in the Management Studio of primary database and if the Database has gone down, then how I can click that button.2. Is it possible to use the secondary database in read only mode while it is in mirror session? I have seen that the secondary database remains in 'restoring' state when it is being mirrored continuously transaction-by-transaction basis by primary database. |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-31 : 07:32:42
|
| Would anybody please comment on this? |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-09-01 : 09:31:26
|
| If anybody could answer the first question, it will help me a lot because we cannot afford to have a dedicated witness server. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-09-01 : 11:59:57
|
| (1) If primary goes down, the mirroring session will automatically failover to your mirror database. the primary/mirror servers will constantly ping each other to check each others availability. (2) Secondary is not accessible for reads. you can create a snapshot of the mirror and read from it but that will be a point in time copy of your data and not real time.. if you need real time you might want to look into replication.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-09-01 : 12:11:11
|
| 1) It will only automatically failover if you have set that option and are using Enterprise Edition. If you aren't like me, run "ALTER DATABASE [Name] SET PARTNER FAILOVER" On the backup database.2) No it's not accessible because the database is in recovery. The database has to be in recovery mode to ship transactions. |
|
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-09-02 : 06:07:55
|
quote:
Originally posted by DaleTurley
1) It will only automatically failover if you have set that option and are using Enterprise Edition. If you aren't like me, run "ALTER DATABASE [Name] SET PARTNER FAILOVER" On the backup database.
Hi thanks!How can I set the automatic failover option using Management Studio? Also, where do we set it: primary DB or secondary DB? |
|
|
|
|
|
|
Database Mirroring question