<div>
<div class="content wysiwyg-content">
The console move SP Foundation Data is not working: says SP modified and cannot move, but I do want to move the data to another drive. &nbsp;I have stumbled across a handful of articles about moving to another server, but nothing particular enough about moving from one drive to another drive.<br />
<br />
On the existing SP data drive, I see \Program Files\Microsoft SQL Server\MSG10_50.SHAREPOINT<wbr />\MSSQL\DAT<wbr />A that contains a handful of .mdf files. &nbsp;Is it as simple as stopping services, copying the folder path to another drive and then restarting? &nbsp;Naw, I didn't think so. &nbsp;I would assume SQL server has to be involved and may a reg setting or two.<br />
<br />
Here's how you can help me:<br />
<br />
1. What services have to be stopped?<br />
2. &nbsp;What files have to be copied?<br />
3. What SQL actions have to be performed?<br />
4. Any reg settings need changing?<br />
5. Any IIS settings need changing?<br />
<br />
Thanks in advance.
</div>
</div>


The console move SP Foundation Data is not working: says SP modified and cannot move, but I do want to move the data to another drive.  I have stumbled across a handful of articles about moving to another server, but nothing particular enough about moving from one drive to another drive.

On the existing SP data drive, I see \Program Files\Microsoft SQL Server\MSG10_50.SHAREPOINT\MSSQL\DATA that contains a handful of .mdf files.  Is it as simple as stopping services, copying the folder path to another drive and then restarting?  Naw, I didn't think so.  I would assume SQL server has to be involved and may a reg setting or two.

Here's how you can help me:

1. What services have to be stopped?
2.  What files have to be copied?
3. What SQL actions have to be performed?
4. Any reg settings need changing?
5. Any IIS settings need changing?

Thanks in advance.

SBS 2011 Need to move SharePoint Foundation datab ases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.