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 |
|
jeffpattison
Starting Member
1 Post |
 Posted - 2009-02-11 : 06:02:43
|
Hi all,Im new to SQL 2005, ive done the microsoft course's 2780 and 2779 but they do not cover what im looking to find out.Basically in my company we have two SQL server running SQL 2005, one is the primary and the other is the backup. the data from the primary is replicated to the backup. we then have a Virtual DNS address that our applications talk to, this the pushes the data to the primary server. I know that there is a failover mechinisum so that if the primary fails it cuts over the the backup and the virual server then tells the data to go to the backup server.my question is where would that cutover machanisum be stored?ThanksJeff  |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-02-16 : 11:36:02
|
| It depends specifically which method is being used. Assuming a few things , the set you've described - let's say you're using a JDBC driver Type 4 - teh n this would normally have 2 ip addresses associated with it . If for some reason , it couldn't connect to the Primary , it would attempt to connect to the Secondary. Can I just point point out , that this is one method ,of manyJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
New to SQL and have a question