MSSQL Install archives - The Multifunctioning DBA
Home > IT Blogs > The Multifunctioning DBA >

The Multifunctioning DBA:

MSSQL Install

Oct 27 2009   3:30AM GMT

Active, Active, Active



Posted by: Colin Smith
MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server, SQL Server 2008, Cluster

Last week I got the chance to work on an Active, Active, Active SQL Server 2008 Cluster install. This was new to me and very fun. We have three physical hosts all using SQL Server 2008 Enterprise Edition. The Servers are also running Windows Server 2008 Enterprise Edition. I worked with one of our windows admins to do the install. First the windows admin set up the windows cluster and assigned all of the storage to the cluster but did not assign it to an application or service. Once that was done we had to set up the Distributed Transaction Coordinator and give it its storage. Now we started the install of SQL Server 2008. Since all of the storage was owned by one server we installed all three instances, one for each node, of SQL Server on that server and that created the different cluster applications for us. Then on each of the other servers we added a node three times, again once for each instance. Now that is complete we can fail over the resources for any instance to any of the physical nodes. Very cool.

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend

Sep 16 2009   3:23PM GMT

Installing SQL Server 2008



Posted by: Colin Smith
MSSQL Server, MSSQL Administration, MSSQL, MSSQL Install

Yesterday I had to install SQL Server 2008 for the first time. I went through it on a development server first before installing on a production server. As I went through the setup process I noticed one thing that I think is long overdue. The Database Configuration step is a great addition to the install process. It is about time that MS allowed us to seperate out where all the Database and Log files will be before we actually do the install. This makes it easy to break out tempdb from the other databases and also to separate your data and log files. Make sure that you take advantage of this and plan out where you want all of the data files and log files to be on the file system. This will save some headache in the future when you have to move all of your databases as well as the system databases.

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend