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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-12 : 14:57:22
|
| I am going to do database mirroring for. I need to configure what needs to be installed for mirror server and witness server with OS perspective. Does Mirror server have to have same hardware and software config as Principle server?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-12 : 19:52:32
|
| Don't need same hardware, OS required depends on sql edition. |
 |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2008-01-14 : 19:15:06
|
| The only hardware I would suggest definately making the same are the nic cards. You don't want your production server to be a gigabit and your mirror server to have a NIC card that is less than a gigabit. I have had this issue... the transactions start to queue and the witness server starts sending out alerts (if you have them set) because the transactions are unable to applied fast enough to the mirror server.I hope this helps!Good Luck!Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
 |
|
|
|
|
|