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 |
|
Ghecko
Starting Member
1 Post |
 Posted - 2008-12-10 : 03:44:22
|
| Hi I am unsure of where this would sit, so i put it hereLet me explain the situationWe are using PDA's with SQL CE installed on them, and a Windows Mobile Based application to create Quotes and InvoicesWe then Synch the 'dirty' data that is one the PDA with the Database on a server through the Internet.It connects using a Replication PublicationThe problem is that I need a Generic Name for the SQL CE to Connect to (the Server) so that when that server Crashes i Can Swop to another one which is set up with the exact Name.I don't want to have to change the Computers name and the SQL server instance name everytime something happens.Is there anyone with a suggestion on what i might be able to do, i have tried to create alias pointing to the server but the SQL CE doesnt support that.I have looked on Google for info and i cannot find anything of value to meThank you in advanceKyle |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2008-12-15 : 14:21:21
|
| You're pretty much describing a cluster: two or more machines configured so that if one of them crashes, the cluster fails-over to a different node. The cluster will have a single name (e.g. SQLMAIN) that references whichever of the nodes is currently active (NODEA, NODEB, etc). Check out clustering in BOL, or have a look in the High Availability forum here. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Generic Name for SQL Server 2005