SQL 2005 Mirroring & failover - SQL Server Forums

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/

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.

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources