SharePoint Project Series.

This is a series of blogs I am writing on SharePoint projects:

Part 1 - Design and Planning Part 2 - Implementation (Stage 1) Part 3 - Implementation (Stage 2)
Part 4 - Training Part 5 - Continued Support Part 6 - Suggested Continued Improvement

Thursday, October 23, 2008

Moving the Windows Internal Database

One big issue I have seen quite a bit of is that the Windows internal database that is stored within SharePoint is kept on the C: Drive. This can cause issues as most application servers have drive partitions that look similar to this:

C:\ Drive (Operating System) - 40gb
D:\ Drive (Data) - 160gb

Or something of that nature. Using Microsoft best practice the rough calculation to decide upon SharePoint database size is to take the corpus size (data size of all your content) and multiply this by 1.75. This will allow enough room for log files and also the search space requirements.

The issue with the Windows Internal database is the default database location is set to c:\windows\sysmsi\ssee\mssql.2005\mssql\data .

You can imagine the issues if you load 80gb of documents into SharePoint.

So here is what to do to move the databases, I would suggest moving them all however you can get away with moving just the content database and the search database.

1. First step is to either stop the SQL service or the SharePoint services (there are around 5). It is up to you which one to stop just make sure you have informed your users and also stopped the SharePoint IIS web site.

2. Next You will need to detach the database from SQL.

3. Open the SQL Management Studio as explained in my previous post and connect to the Windows Internal Database.

4. Expand databases and the Right click on the database you want to move, in this case WSS_Content, click on tasks and click on detach.

5. Now you can go into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data folder and copy the physical database files. Make sure you copy BOTH files --> MDF and LDF.

6. Copy the files to an appropriate location (such as d:\sharepoint\data or d:\databases\sharepoint).

7. Go Back into Microsoft SQL Management Studio and Right Click on Databases and Click on Attach.

8. Now all youy have to do is click on 'Add' and then browse to the location you copied your WSS_Content database files to and add the MDF file (SQL will automatically pick up the LDF file).

9. Restart the SharePoint or SQL Services and then retart the IIS web sites.

10. The databases are now successfully migrated to a new location.

Repeat these steps for your search and admin config databases if you so chose.

Good Luck!

1 comment:

Blogger said...

BlueHost is definitely one of the best web-hosting company for any hosting plans you require.