<div>
Make full backups first after stopping any users from transacting in Sharepoint.<br />
Verify the backups.<br />
<br />
If all goes badly, you can restore these backups to your original system.<br />
<br />
Then detach the databases, move them and attach on your new system.
</div>


Make full backups first after stopping any users from transacting in Sharepoint.
Verify the backups.

If all goes badly, you can restore these backups to your original system.

Then detach the databases, move them and attach on your new system.

<div>
I agree with Achilles, there are a lot of stored process that are in the Sharepoint config db that poll the other data bases constantly without any user input.<br />
<br />
You will need to bring the sp servers up after your sqlserver in the new environment, I think if you start your sp server up first there will be connectivity issues.<br />
<br />
Do the backups too, just in case.
</div>


I agree with Achilles, there are a lot of stored process that are in the Sharepoint config db that poll the other data bases constantly without any user input.

You will need to bring the sp servers up after your sqlserver in the new environment, I think if you start your sp server up first there will be connectivity issues.

Do the backups too, just in case.

<div>
<div class="content wysiwyg-content">
Hi, Due to some reason I have to move all the MOSS 2007 databases from one drive to another drive.<br />
Since I had already moved content databases and now want to move SharePoint config database , SharePoint Admin database, SSP and Search related database.<br />
And for movement using Detach/ Attach method.<br />
So please let me know while moving SharePoint config database , SharePoint Admin database, SSP and Search related database what precaution have to take?
</div>
</div>


Hi, Due to some reason I have to move all the MOSS 2007 databases from one drive to another drive.
Since I had already moved content databases and now want to move SharePoint config database , SharePoint Admin database, SSP and Search related database.
And for movement using Detach/ Attach method.
So please let me know while moving SharePoint config database , SharePoint Admin database, SSP and Search related database what precaution have to take?

Detach/attach SharePoint 2007 Configuration Database?

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.

Microsoft SharePoint

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.