Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Can Windows 2003 Server implicitly replicate SQL Server 20..

 
   Database Forums (Home) -> Replication RSS
Next:  Insert Query Help  
Author Message
JB

External


Since: Nov 19, 2008
Posts: 9



(Msg. 1) Posted: Wed Nov 19, 2008 4:24 pm
Post subject: Can Windows 2003 Server implicitly replicate SQL Server 2005?
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hello

Since Windows 2003 Server Domain Controllers replicate themselves, I was
wondering when Windows 2003 Server exists as a domain controller in a domain
and SQL Server also resides on that domain controller and there is a second
Windows 2003 Server domain controller in that domain that the first Windows
2003 Server domain controller is replicating itself on, does SQL Server also
get replicated onto that second domain controller?

The reason I ask is because I want to know if Sql Server 2005 does get
replicated when
Windows 2003 server gets replicated, if the first domain controller goes
down can't the user pick up right where they left off at by logging into that
second domain controller?
--
JB

 >> Stay informed about: Can Windows 2003 Server implicitly replicate SQL Server 20.. 
Back to top
Login to vote
Hilary Cotter

External


Since: Oct 09, 2005
Posts: 78



(Msg. 2) Posted: Mon Nov 24, 2008 10:43 am
Post subject: RE: Can Windows 2003 Server implicitly replicate SQL Server 2005? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

No, only the active directory is replicated.

The technology you are looking for is called clustering or database mirroring.

"JB" wrote:

> Hello
>
> Since Windows 2003 Server Domain Controllers replicate themselves, I was
> wondering when Windows 2003 Server exists as a domain controller in a domain
> and SQL Server also resides on that domain controller and there is a second
> Windows 2003 Server domain controller in that domain that the first Windows
> 2003 Server domain controller is replicating itself on, does SQL Server also
> get replicated onto that second domain controller?
>
> The reason I ask is because I want to know if Sql Server 2005 does get
> replicated when
> Windows 2003 server gets replicated, if the first domain controller goes
> down can't the user pick up right where they left off at by logging into that
> second domain controller?
> --
> JB

 >> Stay informed about: Can Windows 2003 Server implicitly replicate SQL Server 20.. 
Back to top
Login to vote
JB

External


Since: Nov 19, 2008
Posts: 9



(Msg. 3) Posted: Mon Nov 24, 2008 5:11 pm
Post subject: RE: Can Windows 2003 Server implicitly replicate SQL Server 2005? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks Hilary Cotter

NT4.0 didn't have active directory so when it replicated it replicated
everything to the other PDC so I was wondering if Windows 2003 Server does
the same thing. Now that you told me now I know that it only replicates
Active directory.

Thanks
--
JB


"Hilary Cotter" wrote:

> No, only the active directory is replicated.
>
> The technology you are looking for is called clustering or database mirroring.
>
> "JB" wrote:
>
> > Hello
> >
> > Since Windows 2003 Server Domain Controllers replicate themselves, I was
> > wondering when Windows 2003 Server exists as a domain controller in a domain
> > and SQL Server also resides on that domain controller and there is a second
> > Windows 2003 Server domain controller in that domain that the first Windows
> > 2003 Server domain controller is replicating itself on, does SQL Server also
> > get replicated onto that second domain controller?
> >
> > The reason I ask is because I want to know if Sql Server 2005 does get
> > replicated when
> > Windows 2003 server gets replicated, if the first domain controller goes
> > down can't the user pick up right where they left off at by logging into that
> > second domain controller?
> > --
> > JB
 >> Stay informed about: Can Windows 2003 Server implicitly replicate SQL Server 20.. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]