dbTalk Databases Forums  

Synchronization

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Synchronization in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GUSS
 
Posts: n/a

Default Synchronization - 10-27-2008 , 01:16 PM






i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM






Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Synchronization - 10-27-2008 , 01:30 PM



Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database
and
having the two databases synchronize with each other including all objects
and forms?

Thanks,

G


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.