SQLServer 2008 Failover

arjun_004 · Post by **arjun_004** » Tue Jul 31, 2012 6:33 am

Hi All,

We have requirement to load data in SQLServer 2008 Standard R2 database.
In addition we have to handle the Database fail over.
If Principle server is down, then jobs should load into the mirror server.

Do we have any option in Datastage/DSN to specify the Mirror sql server. ??

Thanks in advance.

ArndW · Post by **ArndW** » Tue Jul 31, 2012 7:53 am

I haven't done failovers on SQL-Server, but doesn't the failover database inherit the database name and other attributes, making a failover almost transparent to the database users and not requiring multiple settings?

jwiles · Post by **jwiles** » Tue Jul 31, 2012 9:05 am

I'm not aware of a setting for this within DataStage itself, but the included DataDirect ODBC drivers may provide support for failover with SQL Server.

Regards,

chulett · Post by **chulett** » Tue Jul 31, 2012 10:02 am

There's failover and then there's transparent failover. Which are you looking for? Disclaimer: I have no clue if SQL Server supports the latter, I just know the difference exists as I've had to deal with it in other environments in the past.

jwiles · Post by **jwiles** » Tue Jul 31, 2012 10:37 am

I think SQL Server 2012 may support a transparent failover, but not sure if 2008 R2 does unless it's through Windows Clustering.

Regards,

arjun_004 · Post by **arjun_004** » Tue Jul 31, 2012 11:28 pm

In case of Oracle we have the option in odbc.ini,We can specify the alternate server in odbc.ini

Looking for the similar option Sqlserver 2008.
Will it work if we specify the alternate server in odbc.in while creating DSN for sql server ??

chulett · Post by **chulett** » Wed Aug 01, 2012 7:05 am

Thought probably not conclusive, there's nothing here that seems like what you are looking for.