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
 Other SQL Server Topics (2005)
 SQL 2005 Mirroring & failover

Author  Topic 

TRIT
Starting Member

3 Posts

Posted - 2015-03-10 : 18:11:16
Hi all,

I have one existing SQL 2005 server with 10 databases. Now I need to implement database mirroring & failover. Could someone show me what steps I need to do. Currently I have a new server with Windows 2008 R2 installed. I know I need to install SQL 2005 on the new server but I don't know how should I install it (which features need to select, how should I name the instance for new server, etc... ). Please help.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-10 : 18:19:58
There's nothing special to select to get database mirroring installed. It comes with the engine. Which edition of SQL Server do you have.

Here are a couple of blog articles I wrote on the topic:
http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx
http://weblogs.sqlteam.com/tarad/archive/2008/05/04/60585.aspx

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

TRIT
Starting Member

3 Posts

Posted - 2015-03-11 : 11:14:55
Thank you Tara. I have SQL 2005 Standard. I will read the articles. Thanks for your help.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-11 : 12:01:25
With Standard edition, you are limited to the synchronous/SAFETY=ON option, so make sure that the other failover partner commits are speedy. It should not be at a DR site for instance, or you'll have a performance hit.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -