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 Planning and Monitoring SQL Server Storage for SharePoint: Performance Recommendations and Best Practices and this KB article How to defragment Windows…


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….