O'Reilly logo

Microsoft® SharePoint™ 2003 Unleashed, Second Edition by Michael Noel, Colin Spence

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

Performing SQL Database Level Backups and Restores

SharePoint stores configuration and site content in SQL Server databases. The main SharePoint database is the configuration database. The configuration database stores configuration settings for all SharePoint servers in a deployment, including virtual servers. It is imperative that all databases residing on SQL Server, especially the configuration database, are backed up regularly to minimize data loss.

There are different methods to back up and restore a SharePoint database in SQL Server. It is possible to back up databases with the SharePoint Portal Server Data Backup and Restore utility, SQL Server Enterprise Manager backup utility, or T-SQL scripts fired by SQL Server Query Analyzer. In ...

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