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 ...
Get Microsoft® SharePoint™ 2003 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
