Web Farm Question
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Web Farm Question

 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services
Author Message
Johnnie Rotten
Guest
Posted: Tue Nov 08, 2005 9:51 pm    Post subject: Web Farm Question Reply with quote
Hello,

We have multiple SQL servers and want to balance the content database load
across them. What is the potential issues with the configuration database
hosted on one server and the content database hosted on another? Specially
in relation to some kind of disaster recovery scenario.

Thanks!!!!!!
Back to top
Dustin Miller
Guest
Posted: Wed Nov 09, 2005 9:51 pm    Post subject: Re: Web Farm Question Reply with quote
No issue, that I can discern. A content database is an atomic
collection of content from a virtual server. The configuration database
tells SharePoint the name of the content database for a given IIS
virtual server (among other things).

There is no "sync" between a site and a content database. A content
database /is/ the site.

Sorry if my explanation is unclear, I guess it's hard to verbalize the
explanation sometimes. :)

-----
Dustin Miller
SharePoint University (Community) [http://www.sharepointu.com]
SharePoint Bootcamp (Training) [http://www.sharepointbootcamp.com]
SharePoint Blogs (Blogs) [http://www.sharepointblogs.com]
SharePoint Experts (Business) [http://www.sharepointexperts.com]

Johnnie Rotten wrote:
Quote:
I'm sorry, I guess I didn't clearly state the question.

The content & configuration data bases are being backed up regularly and we
even use stsadm.exe to backup the websites periodically.

I realize that some WSS components are more important then others.

In a server farm/remote SQL configuration, if we're doing the above
mentioned backups, is there a potential issue with performing a recovery
procedure. Steps to accomplish before others or knowing that the websites
and content databases are unsynchronized.

Your answer is appreciated, but if I receive another like this....I guess I
would have to rely on "hands on" testing.

Thanks for your time.

"Dustin Miller" <dustin-s-p-a-m@sharepointexperts.com> wrote in message
news:uC89aIW5FHA.3428@TK2MSFTNGP10.phx.gbl...
Well, I've always believed that a loss of the configuration database is
not the end of the world (though it will make life a bit difficult to
restore in a web farm environment). It's the content database that's 100%
important in terms of disaster recovery.

I don't really see how your proposed setup would make disaster recovery
any easier or more complex, honestly. If there's a failure, there's a
failure.

-----
Dustin Miller
SharePoint University (Community) [http://www.sharepointu.com]
SharePoint Bootcamp (Training) [http://www.sharepointbootcamp.com]
SharePoint Blogs (Blogs) [http://www.sharepointblogs.com]
SharePoint Experts (Business) [http://www.sharepointexperts.com]

Johnnie Rotten wrote:
Hello,

We have multiple SQL servers and want to balance the content database
load across them. What is the potential issues with the configuration
database hosted on one server and the content database hosted on another?
Specially in relation to some kind of disaster recovery scenario.

Thanks!!!!!!

Back to top
Johnnie Rotten
Guest
Posted: Wed Nov 09, 2005 9:51 pm    Post subject: Re: Web Farm Question Reply with quote
I'm sorry, I guess I didn't clearly state the question.

The content & configuration data bases are being backed up regularly and we
even use stsadm.exe to backup the websites periodically.

I realize that some WSS components are more important then others.

In a server farm/remote SQL configuration, if we're doing the above
mentioned backups, is there a potential issue with performing a recovery
procedure. Steps to accomplish before others or knowing that the websites
and content databases are unsynchronized.

Your answer is appreciated, but if I receive another like this....I guess I
would have to rely on "hands on" testing.

Thanks for your time.

"Dustin Miller" <dustin-s-p-a-m@sharepointexperts.com> wrote in message
news:uC89aIW5FHA.3428@TK2MSFTNGP10.phx.gbl...
Quote:
Well, I've always believed that a loss of the configuration database is
not the end of the world (though it will make life a bit difficult to
restore in a web farm environment). It's the content database that's 100%
important in terms of disaster recovery.

I don't really see how your proposed setup would make disaster recovery
any easier or more complex, honestly. If there's a failure, there's a
failure.

-----
Dustin Miller
SharePoint University (Community) [http://www.sharepointu.com]
SharePoint Bootcamp (Training) [http://www.sharepointbootcamp.com]
SharePoint Blogs (Blogs) [http://www.sharepointblogs.com]
SharePoint Experts (Business) [http://www.sharepointexperts.com]

Johnnie Rotten wrote:
Hello,

We have multiple SQL servers and want to balance the content database
load across them. What is the potential issues with the configuration
database hosted on one server and the content database hosted on another?
Specially in relation to some kind of disaster recovery scenario.

Thanks!!!!!!
Back to top
Dustin Miller
Guest
Posted: Wed Nov 09, 2005 9:51 pm    Post subject: Re: Web Farm Question Reply with quote
Well, I've always believed that a loss of the configuration database is
not the end of the world (though it will make life a bit difficult to
restore in a web farm environment). It's the content database that's
100% important in terms of disaster recovery.

I don't really see how your proposed setup would make disaster recovery
any easier or more complex, honestly. If there's a failure, there's a
failure.

-----
Dustin Miller
SharePoint University (Community) [http://www.sharepointu.com]
SharePoint Bootcamp (Training) [http://www.sharepointbootcamp.com]
SharePoint Blogs (Blogs) [http://www.sharepointblogs.com]
SharePoint Experts (Business) [http://www.sharepointexperts.com]

Johnnie Rotten wrote:
Quote:
Hello,

We have multiple SQL servers and want to balance the content database load
across them. What is the potential issues with the configuration database
hosted on one server and the content database hosted on another? Specially
in relation to some kind of disaster recovery scenario.

Thanks!!!!!!

Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services All times are GMT
Page 1 of 1

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




New Topics Powered by phpBB