Move all databases (Office SharePoint Server 2007)

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:

  1. Move all databases to a different database server (This also covers migrating to newer software such as Server 2008 and SQL 2008).
  2. 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!

Contact us

Partner with Us for Comprehensive IT

We’re happy to answer any questions you may have and help you determine which of our services best fit your needs.

Your benefits:
What happens next?
1

We Schedule a call at your convenience 

2

We perform a discovery of your current and future needs

3

We prepare a proposal