Database Maintenance for Microsoft SharePoint Products and Technologies

Database maintenance is essential for the health and the performance of your SharePoint® Products and Technologies applications (EPM and/or MOSS). Check these white papers: Database Maintenance for Microsoft® SharePoint® Products and Technologies http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409 Planning and Monitoring SQL Server Storage for SharePoint: Performance Recommendations and Best Practices http://go.microsoft.com/fwlink/?LinkID=105623&clcid=0x409 and this KB article How to defragment Windows…

1

Moving the SharePoint Databases to a new SQL server instance

(Updated 20071004) Well, you just have a brand new database server and you need to move all the databases from your old SQL server to the new SQL server. This is what I did to change the SQL server instance of an existing EPM farm. You cannot just backup and restore (or detach it) the databases….

6