Moving Sharepoint SQL Databases - Sharepoint Services 2.0
Posted on 2011-10-31
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.