...
For more information about this process, please consult your MSSQL documentation or contact your IT Support Team.
Backup a Database
The following procedure backs up the TFS database.
Critical: This MUST be performed on the server/workstation that hosts the TFS database. |
|---|
- Open SQL Server Management Studio Express (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
- Login to Microsoft SQL Server.
- In the Object Explorer pane, expand: [server name] > Databases
- Right-click on the The Finance Shop database (e.g., TFSMain) and select Tasks > Back Up. The Back Up Database (General Page) dialog will be displayed.
- Specify a Name and Destination for the backup file, if different from the default name and destination details.
...
Example: A typical example is to backup the database file (.bak file) to the following folder location: \[tfs folder]\Service\tfsBackup_[todaysDate]
Restore a Backup
The following procedure restores a backup of the TFS database.
...