sharepoinTony

@info – The practical side of SharePoint

Moving MOSS 2007 SQL Databases

Posted by sharepoinTony on May 10, 2010

I have a MOSS 2007 implementation that consists of a SharePoint “farm” on one server and the SharePoint databases on a shared SQL Server. The SharePoint server is running Windows Server 2008 and is 64-bit, but the SQL Server is on Windows 2003 with SQL 2005.

One of the other applications using this shared SQL server is fairly critical and the performance is starting to take a hit. This has opened an opportunity to get our SharePoint databases moved to a dedicated SQL server.

I don’t know if anyone else out there has a similar hardware situation or not, but I thought I would try to post a few thoughts as I go through this process over the next few weeks. Let me know if you have already done this or think I am taking a wrong turn as I go.

One idea I have is to take full advantage of the need to move and upgrade to a SP2010 compliant SQL system – and go to SQL 2008 while I am at it. Good idea or bad idea?

Another thought is to investigate whether or not I can make use of our recently implemented DocAve Data Protection software from AvePoint. Maybe I could ‘act’ like a disaster happened and I need to restore my SQL Server on a new box. I wonder if that would work, and if it would be any faster/easier?

Let the investigation begin.

My first stop is with this TechNet article, Move all databases (Office SharePoint Server 2007): http://technet.microsoft.com/en-us/library/cc512725.aspx – my light reading for tonight.

Continue to Part 2

Advertisements

One Response to “Moving MOSS 2007 SQL Databases”

  1. […] This post was mentioned on Twitter by 是村 潤(Jun Koremura) and spTony Rockwell, spTony Rockwell. spTony Rockwell said: Moving MOSS 2007 SQL Databases: http://wp.me/prfLI-8e […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: