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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Datbase Mirroring Issues

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.
Go to Top of Page

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 Davis
Senior SQL Server DBA
For more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/
Go to Top of Page
   

- Advertisement -