Moving Sharepoint SQL Databases - Sharepoint Services 2.0

Posted on 2011-10-31
Medium Priority
Last Modified: 2012-05-12

Wonder if anyone can help me... I'm trying to move an SQL database which is assigned to a SharePoint Site to a different drive - There is very little space left on the C Drive and lots of space on the D Drive.

A previous Network manager has already moved our main site's database  ( I have 2 or three) To the D Drive, following a Knowledge base article, However When I attempt to make new sites, the databases are still created in the default folder on the C Drive.
When I Try to move the database, I then am faced with 2 Config Databases, and am unsure which to use.  I attempted a move last week and the config file I used meant that share point did not work at all (Site not found errors)

I wonder if anyone can shed some light as to the best way to achieve having all the databases (or at least any new ones) on the D Drive.

Thanks :)
Question by:e2e01
  • 5
  • 3
LVL 12

Expert Comment

ID: 37055745
Easiest way is to do a backup of the database and then restore it -and when restoring it,on the file options,point the database files to the other drives.Default is c:/(your sql server path)/data


Author Comment

ID: 37055757
How do you mean? If I'm restoring it by creating a new site: i.e. "stsadm.exe -o createsiteinnewdb -url companyweb/sites/example"  Would I then make "-databasename" "D:\folder I want here" ?
LVL 12

Expert Comment

ID: 37055764
Am talking about sql,using sql server management studio -not sharepoint.In this case,you'd have to run sharepoint configuration wizard afterwards.

Another way is to run this script.
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.


Author Comment

ID: 37055863
If you don't have Server management studio - isn't there a way to use "Osql........"Sp_detach_db"" ?

Author Comment

ID: 37056522
Ok, I've installed sql manager studio, changed the default database path like you suggested and it's still making new databases in the default path. ANY IDEAS?

Accepted Solution

e2e01 earned 0 total points
ID: 37082839
I have managed to change the default path for the databases.

Author Closing Comment

ID: 37105829
It worked.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question