Issue
When Scheduling database backups for ION_ Network and ION_Data in Task Scheduler, the event shows that the task was completed successfully but no backups were generated.
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
ION Enterprise
Environment
Database maintenance tasks using Windows Task Scheduler
Cause
No backups are being generated from Task Scheduler
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Open SQL Management Studio, login with windows authentication and expand Databases, expand ION_Network, then expand Security andUsers, right click on servername\IONMaintenance and select properties. Under User name make sure the IONMaintenance user is associated with the login name.
The screen shot below shows no IONMaintence under the login name and is grayed out, this is the reason no backups are generated for ION_Data and ION_Network.
To resolve this problem, please follow the steps below:
1. Delete the IONMaintenace User and recreate it by right clicking on Users and selecting New User enter severname\IONMaintenance
2. Make sure the IONMaintenance user shows under User name and Login name.
3. Under Database role membership, make sure db_backupoperator, db_ddladmin and Maintenance are checked.
The screen shot below shows correct configuration for IONMaintenace user
4. Repeat the same steps for ION_Data.
When Scheduling database backups for ION_ Network and ION_Data in Task Scheduler, the event shows that the task was completed successfully but no backups were generated.
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
ION Enterprise
Environment
Database maintenance tasks using Windows Task Scheduler
Cause
No backups are being generated from Task Scheduler
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Open SQL Management Studio, login with windows authentication and expand Databases, expand ION_Network, then expand Security andUsers, right click on servername\IONMaintenance and select properties. Under User name make sure the IONMaintenance user is associated with the login name.
The screen shot below shows no IONMaintence under the login name and is grayed out, this is the reason no backups are generated for ION_Data and ION_Network.
To resolve this problem, please follow the steps below:
1. Delete the IONMaintenace User and recreate it by right clicking on Users and selecting New User enter severname\IONMaintenance
2. Make sure the IONMaintenance user shows under User name and Login name.
3. Under Database role membership, make sure db_backupoperator, db_ddladmin and Maintenance are checked.
The screen shot below shows correct configuration for IONMaintenace user
4. Repeat the same steps for ION_Data.
Released for:Schneider Electric USA
