RE: [aus-dotnet] Replication.....in dotnet

[Greg Low]

Hi Glenn,
 
I've been in a class this week where we've been setting it up and using it. I'm doing so on the December CTP edition. I must admit it's pretty interesting. To get automatic failover though, you need:
 
1. A 3rd SQL box that plays the role of a "Witness"
2. Updated MDAC stacks that are aware of automated failover on mirroring. (There is also a new connectionstring option that allows you to specify the failover server for even more redundancy).
 
HTH,
 
Greg

________________________________

From: dotnet-owner@xxxxxxxxxxx on behalf of Glenn Stephens
Sent: Fri 3/12/2004 12:06 PM
To: dotnet@xxxxxxxxxxx
Subject: Re: [aus-dotnet] Replication.....in dotnet


At the Microsoft ISV community day last week, they mentioned a SQL Server 2005 feature of database mirroring over a network connection. This sounds like a killer feature and I'm waiting to try it out when I get the chance. Has anyone else had a play with this feature on Beta 2 yet? I'm curious to hear any thoughts.
 
Cheers,
Glenn

	----- Original Message ----- 
	From: anthony <mailto:list@xxxxxxxxxxxxxxx>  
	To: dotnet@xxxxxxxxxxx 
	Sent: Friday, December 03, 2004 11:49 AM
	Subject: RE: [aus-dotnet] Replication.....in dotnet

	But this still relies on sql being setup in replication..if i am using different hosting providers i cannot set this up.
	 
	Hoping there was technique to do this without relying on the database to do it.
	 

________________________________

	From: dotnet-owner@xxxxxxxxxxx [mailto:dotnet-owner@xxxxxxxxxxx] On Behalf Of Aaron Bull
	Sent: Friday, 3 December 2004 11:39 AM
	To: dotnet@xxxxxxxxxxx
	Subject: Re: [aus-dotnet] Replication.....in dotnet
	
	
	Sql replication ?

		----- Original Message ----- 
		From: anthony <mailto:list@xxxxxxxxxxxxxxx>  
		To: dotnet@xxxxxxxxxxx 
		Sent: Friday, December 03, 2004 10:48 AM
		Subject: [aus-dotnet] Replication.....in dotnet

		Has anyone had any experience with setting up a system where data can be entered from separate locations.
		 
		I am deciding whether i should be using GUIDs or some other technique so i can provide a redundancy layer for my web application.  If my website goes down i want a another database to take over.
		 
		 
		 
		Anthony

<<winmail.dat>>