Mike's PBX Cookbook

DP Database Restore

Turn off services and applications:

  1. Close all Switchboard and related applications on the host PC and any other PC's with Switchboard modules referencing the database
  2. For all PC's referencing the base, the 'Mettoni Server Update' service must be stopped, to do this, on each PC go to the Start menu, in the 'Search Programs and Files' box, enter 'services.msc', at the top of the search results, click on 'services'
  3. The 'Services' window appears, under the right hand 'Services (Local)' section, locate 'Mettoni Server Update', if the 'Status' shows as 'Started', right click on the service and select 'Stop'
  4. Go to the next section below

Restore database:

  1. Open SQL Server Management Studio
  2. The 'Server Type' will be pre-populated with 'Database Engine', 'Server name' should be the PC's network name followed by a '\DATAPULSE' and 'Authentication' should already be populated as 'Windows Authentication', 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 'Restore', then 'Database...'
  6. In the 'Restore Database - Intuition' window, under 'Source for restore', the 'From device' radio button, then click the '...' button to the right
  7. The 'Specify Backup' window appears, 'File' should be selected for the 'Backup media', click on the 'Add' button
  8. In the 'Locate Backup File' window, go to the backup folder in the 'c:\' drive, click on the backup file, the file name should now appear at the bottom of the window in the 'File name' box, click 'OK' for the next two screens
  9. You return are returned to the 'Restore Database - Intuition' window, in the 'Select the backup sets to restore' section, click the 'Restore' checkbox next to the 'Intuition-Full Database Backup'
  10. Under 'Select a Page', click on 'Options'
  11. Under 'Restore options', click the 'Overwrite the existing database' checkbox, then click 'OK'
  12. The 'Progress' in the lower left should show 100% and a window appears stating 'The restore of the database 'Intuition' completed successfully', click 'OK'
  13. Close SQL Server Management Studio Express
  14. Copy this backup to the backup folders of any computers using the same database

Reset Mettoni schema ownership:

  1. Open SQL Server Management Studio
  2. Under 'Object Explorer', click on the '+' sign next to 'Databases', click on the '+' sign next to Intuition, click on the '+' sign next to 'Security', click on the '+' sign next to Users, and double click on the 'guest' user
  3. The 'Database User - guest' window appears, under 'Schemas owned by this user' select the check boxes next to 'db_datareader', 'db_datawriter', 'db_owner', and 'mettoni'
  4. In the same window, under 'Database role membership' select the check boxes next to 'db_datareader', 'db_datawriter', and 'db_owner', then click 'OK'
  5. Under 'Users', right click on 'mettoni' and select 'Delete'
  6. An error box will appear asking if you would like to delete the schema and the user, select 'NO'.
  7. The 'Delete Object' window appears, click 'OK'
  8. Right click on ' Users' and select 'New User...'
  9. The 'Database User - New' window appears, for 'User name' enter 'mettoni' and 'Login Name'
  10. In the same window, under 'Schemas owned by this user' select the check boxes next to 'db_datareader', 'db_datawriter', 'db_owner', and 'mettoni'
  11. Then, under 'Database role membership' select the check boxes next to 'db-datareader', 'db_datawriter', and 'db_owner', then click 'OK'
  12. Under users, you should now see the user 'mettoni' returned to the list
  13. Close the Microsoft SQL Server Management Studio Express

Turn on services and applications:

  1. For all PC's referencing the base, the 'Mettoni Server Update' service must be restarted, to do this, on each PC go to the Start menu, in the 'Search Programs and Files box', enter 'services.msc', at the top of the search results, click on 'services'
  2. The 'Services' window appears, under the right hand 'Services (Local)' section, locate 'Mettoni Server Update', if the 'Status' shows as 'Stopped', right click on the service and select 'Start'
  3. Close the services window
  4. You may now resume using the 'Switchboard' and related applications