Backing Up and Restoring an SQL Database

You can use an SQL Server database as the Plant Applications database or Unified Manufacturing Database (UMDB).

1. Back up the database on the SQL Server instance.
   See How to create a database backup (Enterprise Manager) in the SQL Server Books Online.
2. Make a copy of the backup file.
   Because SQL Server Management Studio does not allow restoration from a network location, the backup file must be copied to the local disk of the SQL Server instance.
3. Restore the database to the SQL Server instance.
   See How to: Create a New Database from an Existing Database Backup (SQL Server Management Studio in the SQL Server Books Online.
4. After the database has been restored, ensure that permissions are set up correctly in the Plant Applications database. From SQL Server Management Studio, run the following script to rebuild the SQL permissions

   exec sp_Revokedbaccess 'ProficyDBO' 
            go 
            exec sp_Revokedbaccess 'ComXClient' 
            go  
            exec sp_Revokedbaccess 'ProficyConnect'
            go 
            exec SpSupport_ChangeDBOAccount 'Proficydbo','ProficyDBO'