December 9, 2005 at 7:25 am
Hi,
This email is a follow-up to my questions regarding the backup/restore questions in Books Online. There were some more speed bumps here. They are as follows:
Is your database server part of a SQL Server 2000 failover cluster for high availability? Please explain what a failover cluster is and how that impacts high availability. And how this question is relevant for backup/restore techniques.
Is your database in a multi-server environment with centralized administration? What is a multi-server environment with centralized administration and how is this important as far as backups and restores are concerned?
I would highly appreciate if you shed some light on the above.
Karim
December 9, 2005 at 10:52 am
Clustering is a feature of the operating system which allows you to use redundant hardware (more than one server) to provide services. SQL Server's supports failover clustering. What that means is only one physical server can be running a particular SQL Server instance at a time. However, in the event of a hardware (and some OS) failure on the server SQL Server is currently running on, another server could take over and run the same SQL Server, hopefully transparent to any clients. When dealing with clusters, you have to plan on what resources can be seen by the SQL Server.
Information on clustering:
Windows Server 2003 Clustering Services
Multi-server environment means more than one server. Centralized administration means exactly what it says... where all administration over all the servers is done from one place. In other words, if I have servers in Tokyo, Bangkok, New York and Colorado, I might be managing them primarily from Colorado. That's centralized administration. However, if I have IT staffs at each location responsible for the servers at that location, that's not centralized administration. How backups and restores are handled are therefore addressed by how the servers are administered. It's important to understand how the organization does this to ensure your SQL Server data is backed up appropriately.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply