Wednesday, August 6, 2008

SharePoint database options for SBS 2008

So, you’re thinking that since you went out and purchased SBS 2008 Premium, which includes SQL Server 2008 on a second server, you’d like to use that to hold the content databases for Sharepoint v3. Remembering, this is all RC0,1 stuff, here’s my take.

 

After SBS 2008 is installed, SharePoint v3 will be configured to use SQL 2005 Embedded Edition on the first SBS 2008 server (no other option from what I see). Now, before you start adding data to SharePoint you can go into the SharePoint Central Administration and specify a new default database server. Next, you are going to have to migrate the existing Companyweb databases (from SQL 2005 Embedded) to the second server with SQL 2008. Alternatively, you are going to have to create new content databases for Companyweb. Why? I’ll assume you still want the SBS 2008 wizards to work and they work on http://companyweb. Thus, it is probably easier to simply shift or recreate the Companyweb databases than try and create a completely new application and make that Companyweb. Is only my guess.

 

But hang on, let’s have a think about this. You probably decided to go with SQL 2008 rather than SQL 2005 Embedded Edition for performance reasons but my guess is that any gains would be lost as you have to send and receive data between servers. Remember the Sharepoint Web site is on the first SBS 2008 box while the content database is on the second SBS 2008 box.

 

Ok, since Sharepoint is a free application you could install it on the second SBS 2008 (which has SQL 2008). That way you get the “performance” improvement of SQL 2008 and no loss of “performance” because of cross network traffic. Ah, yes but now Sharepoint won’t work with any of the inbuilt SBS 2008 wizards because it is a new instance. I’m sure you could rectify that but my guess it would be “unsupported”

 

So I question what “performance” improvement is expected from SQL 2008? I have not found anyone who can tell me whether SQL 2005 Standard is better than SQL 2005 Embedded or SQL 2008. Therefore, I’d say you are probably better staying with the standard Sharepoint v3 install on SBS 2008 using SQL 2005 Embedded Edition. So unless you are planning another use for SQL 2008 why do you need SBS 2008 Premium? There are legitimate reasons for SBS 2008 Premium but if you are just getting it for Sharepoint maybe there isn’t.