Mike's PBX Cookbook

DP Database Backup

Backup database:

  1. Open SQL Server Management Studio dpbup1.png
  2. The 'Server name' and 'Authentication' should already be populated, click 'Connect' (if the fields are not populated, the 'Server name' should be the computer's network name followed by '\DATAPULSE' and use 'Windows Authentication' for 'Authentication')
  3. Left side of screen, under 'Object Explorer', click on '+' symbol next to 'Databases'
  4. Right click on 'Intuition'
  5. Select 'Tasks', then 'Back Up' dpbup2.png
  6. In the 'Back Up Database - Intuition' window, under 'Destination', select existing backup location and click 'Remove', then click 'Add' dpbup3.png
  7. The 'Select Backup Destination' window appears, the 'File Name' radio button should be selected, click on the '...' button to the right of the folder path dpbup4.png
  8. In the 'Locate Database Files' window, under 'Select the file', select the backup folder on the c:\ drive and in the 'File name' field enter the name of the backup file to be created (make sure to add the .bak to the file name), click 'OK' for the next two screens dpbup5.png
  9. You return are returned to the 'Back Up Database - Intuition' window, select the name of the path and backup file you just created under 'Destination' dpbup6.png
  10. Under 'Select a Page', click on 'Options'
  11. Under the 'Overwrite media' section, click the 'Overwrite all existing backup sets' radio button, under 'Reliability' select the 'Verify backup when finished' check box and click 'OK' dpbup7.png
  12. The 'Progress' in the lower left should show 100% and a window appears stating 'The backup of the database 'Intuition' completed successfully', click 'OK' dpbup8.png
  13. Close SQL Server Management Studio Express
  14. Copy this backup to the backup folders of any computers using the same database