Creating an SQL Snapshot of a SharePoint Content Database

  • Article

The following steps illustrate how to create a snapshot of a content database:

1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

2. In the Connect to Server dialog box, enter the details for your database server, and then click Connect.

3. In the object explorer pane, expand Databases, right-click the database you want to take a snapshot of, and then click New Query.

A query page will open in the main display area of Microsoft SQL Server Management Studio.

4. Modify and enter the following code example on the query page, and then click Execute.

CREATE DATABASE WSS_ContentSnapshot [NAME OF THE NEW DATABASE]

ON

( NAME =
'WSS_Content' [THE DAATABASE YOU WANT TO SNAPSHOT] ,
 FILENAME = 'C:\SnapShots\WSS_ContentSnapshot.mdf' [LOCATION OF THE FILE]

)

AS SNAPSHOT OF WSS_Content