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 |
|
newsqldba
Starting Member
14 Posts |
 Posted - 2007-08-29 : 12:15:45
|
| hi can anybody please explain what the differences are for linked servers and clustering? cause from what ive read they seem like they do the same thing to me. other than the failover implementation for clustering and its high cost. is there any other difference? same question goes for logshipping and database mirroring. logshipping ships transaction logs to other servers and then restores them there right? how is that different from what mirroring does? thanks for the help |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-29 : 12:18:22
|
Tara, do you have the stamina?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 00:13:44
|
| Clustering is high availability solution, linked server is for distributed query or query data from remote data source, log shipping doesn't switch role automatically when source server goes down while db mirroring is capable of that. You can find details in books online. |
|
|
|
|
|
|
differences between linked servers and clustering?