O'Reilly logo

Windows® SharePoint® Services 3.0 Inside Out by Errin O'Connor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backing Up and Restoring Databases by Using the SQL Server 2005 Tools

Besides the content and configurations databases, WSS 3.0 also has databases in SQL Server for search and indexing. These databases can be backed up with SharePoint Central Administration.

However, you should also have a backup plan for SQL Server in case a disaster occurs, or if the SharePoint backups fail. This plan should back up all the databases, not only the WSS 3.0 databases. No matter what option you choose (full, differential, transaction logs backup), the backups should be tested after they are created.

To reduce the time dedicated to verifying the backups, create a script that copies the backup and restores it on a test server or server farm on which you have a copy ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required