Issue
User may be unsure how to restore an ION Database Backup onto Another Machine.
Product Line
SQL Server 2000
SQL Server 2012
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.0
Environment
Restoring a backup
Cause
User may have need to access ION Database backups on another machine.
Resolution
Note: This procedure will overwrite an active database with a backup; you will need to have performed at least one backup. It is recommended that you create a backup of the current database prior to performing these steps.
Using SQL Server 2012:- From the backup machine, copy the .BAK file from \config\cfg\DBBackups\Data\ to the new machine.
- Open SQL Server Management Studio
- Right-Click the Databases folder > Restore Database
- In the Restore Database window select Device and click the right-hand box labeled "..." to select the desired backup instance
- Click "Add" and navigate to the location of the .bak file, and then select 'OK'.
- The Restore Database window should then be populated similar to the image below.
- Select 'OK' to restore the backup.
Using PME 7.2.x or PME 8.0
Databases can also be restored using the Database Manager located in Management Console.
- From the backup machine, copy the .BAK file from \config\cfg\DBBackups\Data\ to the new machine.
- Open Management Console > Tools > Database Manager
- Right-click on "Databases"
- Select "Restore..."
- In the Restore Database window, select that desired backup instance.
- Verify that the "Restored database name" is ION_Data.
- Select OK.
Udgivet til: Schneider Electric Danmark
Brug for hjælp?
Produktvælger
Find hurtigt og nemt de rette produkter og det rette tilbehør til dine anvendelser.
Få et tilbud
Start din salgsforespørgsel online, så vil du blive kontaktet af en ekspert.
Find forhandler
Find den nærmeste Schneider Electric-distributør.
Hjælpecenter
Find supportressourcer til alle dine behov på ét sted.
