Is there a migration guide for separating the SQL Server from a Microsoft Sharepoint 2007 server?
We have a Microsoft Sharepoint 2007 Standard Server installed together with the Microsoft SQL Server 2005 on the same machine. Right now, we already outgrow the server and need to move the SQL Server out to a separate machine, is there a best practices and/or migration guide that someone has written that illustrates the detailed steps to go about doing so. For example, can the configuration database and the content database move together? Or do we need to have the configuration database still in the same server as Sharepoint 2007? Try Microsoft KB Article 894164 for starters. It was written for 2003, but makes total sense.
