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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2007-03-15 : 13:45:58
|
| for a database mirroring , which stretergy is good.Creating with witness server or without it.?I am firsttime doing this , so i am posting it to the forum..and also if we are creating the database mirroring with witness server for automatic failover , will the witness server need the same amount of harddisk space like the pricipal or mirror server.??thanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-15 : 13:57:57
|
quote:
for a database mirroring , which stretergy is good.Creating with witness server or without it.?
Depends on whether you want automatic failover or not - a witness is required for automatic failover. If you don't want/need automatic failover then you don't need a witness, if you do, you do. quote:
will the witness server need the same amount of harddisk space like the pricipal or mirror server.??
No, the witness server does not need any extra disk space at all, no part of the database is kept on the witness server, it participates purely as another SQL Server that the others can talk to on the network so that automatic failover occurs only when the mirror server and the witness both cannot see the principal. Otherwise the mirror might perform failover simply because it has a problem seeing the principal. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-15 : 14:04:03
|
| We can't afford the performance hit of a two-phased commit nor do we want automatic failover, so we use asynchronous database mirroring.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
database mirroring