...
- 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.
Note Write down the name and destination details.
- Select the Options page.
- Tick: Overwrite all existing backup sets
- Tick: Verify backup when finished
- Click the OK button. The backup will be performed.
- Click the OK button to close the message prompt.
- Close SQL Server Management Studio Express.
- Browse to the backup location (as detailed in Point 5 above).
- Copy the backup file to a secure location.
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.
...