With the advent of Microsoft Office SharePoint Server 2007, I think many administrators will be wanting to upgrade their SQL Server infrastructure to better hardware before migrating from SPSP03 to SharePoint 2007. To this end, Kathy Hughes has written a white paper for Mindsharp titled “How to Move SharePoint 2003 Databases to New MSSQL Server”. This white paper will be posted at Mindsharp's premium content web site on Friday, July 7, 2006. Please be sure to download your copy and look it over. The paper has instructions, screen shots, scenarios and illustrations that will help even the most novice SQL or SharePoint administrator move their databases to a new SQL implementation on new hardware. Here is the text from the first part of the white paper:
--------------------------------------------------------
Purpose of this White Paper
The purpose of this white paper is to explain how to move the Microsoft SharePoint Portal Server 2003 (SPS) databases from an existing MSSQL server to a new MSSQL server.
The SPS databases can grow at a rapid rate. If you underestimated your company’s growth or storage requirements when SPS was deployed, you may find the existing data storage is insufficient. The solution is to move your SPS databases to a separate MSSQL server with additional storage capacity or expandable storage such as a storage area network (SAN).
This paper will cover the recommended methods for preparation of the new MSSQL server, pre-move backup strategies, and post-move checklist. It will also cover considerations such as reestablishing the portal content indexes and site catalogs, and restoration of 3rd party Web parts. The paper will reference a server topology comprising either a single or multiserver scenario within the same domain to demonstrate moving the SPS databases.
This paper will not discuss upgrading your SPS databases from MSDE to MSSQL. In this case, you should consult the Microsoft knowledgebase for details.
This paper is intended for SPS administrators who are familiar with deploying and managing SPS in a multiserver environment. It assumes an understanding of the SPS administrative functions, installation of custom Web parts, and a basic understanding of the MSSQL administrative tools and functions. It does not assume knowledge of programming or MSSQL scripting.
-------------------------------------------------------
Be sure to download your copy on or after Friday, July 7th.
Thanks.
Bill English,
Mindsharp