Moving SharePoint Data Files to Different Location

September 8, 2011 — Leave a comment

Current Situations:
When SharePoint installed, all the data/log files are kept in default (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) location. Now the data is growing and C Drive is running out of space.

Solutions:
Move the data/log files to a drive where you have lot’s of space

1. Backup your entire database which you’re planning to move
2. Turn off SharePoint Services

Office SharePoint Search Service
Windows SharePoint Services Administration
Windows SharePoint Services Search
Windows SharePoint Services Timer
Windows SharePoint Services Tracing
World Wide Web Publishing Service

trun_off_sharepoint_services

turn_off_office_sharepoint_server_search

3. Detach the databases

detach_database_from_sql

clip_image004

Leave all the settings as it is and click OK to detach the database

4. Copy your data/log files from current location and move to destination drive

5. Reattach your databases
Attrach Database in SQL Server

Click add to select the files

Attrach Database in SQL Server Add Files

Click Add and select the location where you moved your database files

clip_image008

once you’re select your database files, Click OK to attach

6. Test your site and if everything’s works fine you can delete the files from old location

7. Start all the services which you stopped.

No Comments

Be the first to start the conversation!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s