If you’re like me, this is definitely in your Top 10 WSS/MOSS 2007 requests.
Never fails, the database server is provisioned with less than adequate storage, or the company utilization and adoption of SharePoint has been more than successful.
None the less, the SharePoint and related databases have or are on track to outgrow their environment. This used to be a trial and error procedure, as there was no clear documentation from Microsoft, and community documentation was, less than complete.
Microsoft and the SharePoint Pros have finalized a the procedure dealing with two separate scenarios:
- Move all databases to a different database server (This also covers migrating to newer software such as Server 2008 and SQL 2008).
- Move all databases to a database server that has the same name ( I want to point out this procedure also works for moving the databases to a new/different hard drive or logical volume)
Move all databases (Office SharePoint Server 2007)
I tested the latter scenario on a single server farm (Server 2008 STD, SQL 2008 ENT) and I have to say, it went flawlessly.
Great job guys!