Showing posts with label mirroring. Show all posts
Showing posts with label mirroring. Show all posts

Thursday, March 8, 2012

[NEWBIE] Replication with MSDE 2000

Hi everybody,
can someone help me about replication ?
I want to install msde2000 on two machines (identical) and keep database
updated like mirroring, so my users can connect to mirrored data if primary
server crashed down.
The two machines are in my LAN with their own IP number
Is it Possible ?
Thanks in advance and sorry of my poor knowledge of MSDE features
Merlinweb
Hi Merlinweb,
Merge replication goes close to doing what you want if you keep it
synchronizing constantly. There is some latency with the updates but that's
ok in many scenarios. It works very well when the servers are on the same
LAN. You will need to consider though, how to make schema changes, etc. as
that introduces quite a few issues.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"il_Leva" <il_levaMACIAO@.hotmail.com> wrote in message
news:41c97bf0$1@.x-privat.org...
> Hi everybody,
> can someone help me about replication ?
> I want to install msde2000 on two machines (identical) and keep database
> updated like mirroring, so my users can connect to mirrored data if
> primary
> server crashed down.
> The two machines are in my LAN with their own IP number
> Is it Possible ?
> Thanks in advance and sorry of my poor knowledge of MSDE features
> Merlinweb
>
|||"Greg Low [MVP]" <greglow@.lowell.com.au> ha scritto nel messaggio
news:uDw9mGI6EHA.2584@.TK2MSFTNGP10.phx.gbl...
> Hi Merlinweb,
> Merge replication goes close to doing what you want if you keep it
> synchronizing constantly. There is some latency with the updates but
that's
> ok in many scenarios. It works very well when the servers are on the same
> LAN. You will need to consider though, how to make schema changes, etc. as
> that introduces quite a few issues.
Thank you very much !
Now I go and search something useful on the net about merge replication.
Cheers
Merlinweb

Saturday, February 11, 2012

@Microsoft: E-Learning Course database mirroring

Hi MS-Guys,

the following E-Learning course has some errors which have to be investigated otherwise the course will be very disappointing for the participants:

Kurs 2938: Datenverfügbarkeitsfeatures in Microsoft? SQL Server? 2005 (this is only the german subject for the course, the link should apply in english versions as well, as the course is actually in english)

While starting the VLab to setup mirroring, the sqlinstance2 and sqlinstance3 is not started (this sure can be done very easily), another point is that you installed RTM version where database mirroring is disabled by default (sure this can be done by swithcing the trace flag, but the course is not about doing administrative tasks, right ? :-) )

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Thanks for your feedback. I have forwarded your feedback through the contact us link with the course. You can do so as well, if you follow the contact us link on the elearning site.|||

Hi,

I tried, but it told me that it couldn′t "process the URL", whatever that means :-)

-Jens