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.
Tony Rockwell - Info 
Tweets that mention Moving MOSS 2007 SQL Databases « sharepoinTony -- Topsy.com said
[…] 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 […]