Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Clustering SQL Server 2008 > Maintaining the Cluster

20.7. Maintaining the Cluster

After you have your SQL Server 2008 cluster up and running (and tested), you are ready to put it into production. This may involve creating new databases, moving databases from older servers to this one, setting up jobs, and so on. In most cases, managing SQL Server 2008 on a cluster is the same as managing it on a noncluster. The key thing to keep in mind is that whenever you access your cluster with any of your SQL Server 2008 administrative tools, such as Management Studio, you will be accessing it using its virtual name and IP address; but if you are using any of the operating system tools, such as System Monitor, you need to point these directly to the node in question (which is usually the active node).

In most cases, as a DBA, you probably will be administering SQL Server 2008 using Management Studio, but sometimes you need to access the individual nodes of the cluster. If you have easy access to the cluster, you can always log on locally; if you prefer remote administration, you can use Terminal Services to access the nodes.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint