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 |
|
d@nnyboy
Starting Member
1 Post |
 Posted - 2009-04-15 : 03:54:06
|
| Hi guys, I have an issue here which you can probably assist me with.Here's the scenario, I support an application that is written in vb and connects tosql server database. It usually reads from a config file the server name and/or the ip addressof the server where the db is hosted. Based on this the only sql server 2005 failover option thatI have used is sql server clustering and it works perfectly since I have the virtual server IP address/name to specify at the config file coupled with the many other advantages of clustering.However not everyone can afford to buy storage facilities. So i'd like some advice on the otherfailover options as im not well conversant with mirroring and logshipping.Specifically i'd want to know with mirroring and logshippin how redirection takes place from the primary server to the secondary server and in my case how does it happen without having to change the servername specified in the config file of each client connecting to the server. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-15 : 17:30:29
|
| in order to use database mirroring you will need to modify the application to try a second server. I know this can be done pretty easily.With the same modification, you could use mirroring, log shipping or replication. Depending on your requirements. |
 |
|
|
|
|
|
SQL server failover