Data Manager Maintenance

1. Start the SOAPware Datamanager
2. Maintenance
3. Scheduling Backups and Maintenance
4. Create a New Scheduled Task
5. Run Once
6. Run Daily
7. Run Weekly
8. Run Monthly
9. Change Existing Schedule
10. Delete Existing Schedule

Start the SOAPware Datamanager

To Start the SOAPware DataManager, Click Start, All Programs, SOAPware, SOAPware DataManager.

If you are running on Windows Vista or 7, you will need to Right Click and “Run as administrator”.

When you start the DataManager, you must login with the database administrator password. This defaults to the postgres user account on the database. (This is the second set of passwords created during the SOAPware Data Server install).

NOTE: The database administration password is NOT the same as the SOAPware Administration password. The database administration account only accesses the Postgres database.

Only use the Advanced section if your server, port or database administration user name is different than the default install.

* Server: Host name or IP address where database is running. Defaults to localhost.
* Port: Port number where database is listening. Defaults to port 5432.
* User Name: The administration user on the database. User must have administration privileges. Defaults to postgres.

Maintenance

Databases need to be optimized and cleaned up routinely for maximum performance. Higher traffic databases should be optimized more often, sometimes daily. Lower traffic databases may only need to be optimized once a week or month.

Optimizations may take from 30 minutes to several hours to complete.

* Run All Optimizations: Perform each optimization. (Recommended)
* Update Statistics: Resets all table statistics, row counts, etc.
* Clear Unused Space: Useful after many deletes to reclaim space left behind.
* Reset Indexes: Refreshes table indexes to help data retrieval.
* Set Maintenance Schedule: This header is collapsible. Click it to view or hide scheduling options. See the Scheduling section for more details on setting a maintenance schedule.
* Optimize Now Button: Click button to perform selected optimizations.

Note: Running optimizations may degrade database performance. We recommend setting your Maintenance schedule to run at night or weekends when database traffic is low.

Scheduling Backups and Maintenance

The DataManager provides an easy-to-use interface to create a Windows Task scheduled event to run your backup and maintenance routines. Simply setup a backup or maintenance task as outlined above, then choose the schedule frequency. When you save the schedule, your task will run at that time.

For advanced users, you can maintain existing tasks using the Windows Task scheduler. For more information, start here at the Microsoft Task Knowledge Base.

Create a New Scheduled Task

After you set your backup or maintenance information, expand the schedule tab by clicking on the down arrow icon.

Under the Run dropdown, you can choose the schedule type from Once, Daily, Weekly or Monthly. Different options will appear depending on what type of schedule you will choose.

Set the Time you wish your task to run. Set your task to run at a time when there is no database activity.

Name your schedule so it will be unique in the Windows Task Manager. If you already have a task with the same name, it will ask if you would like to overwrite the existing task.

Run Once

This option will run your task only once on the specified day and time.

Run Daily

This option will run your task daily. You can choose to skip a number of days.

Run Weekly

Running a task weekly allows you to choose which days of the week to run. You may also skip weeks.

Run Monthly

A Monthly task allows you to set the task to run once a month on a certain day. You may check the months you would like to run the task.

Change Existing Schedule

To change an existing schedule, simply setup a new schedule how you would like with any new backup or maintenance or schedule data and give the same schedule Name as an existing task. This will overwrite the existing task with your new information.

To find a list of your existing schedules, look in the Windows Task Scheduler for your tasks. Go to the Windows Start menu, then open the Control Panel. Open Scheduled Tasks and it will list all your current tasks. You may edit these directly to change the schedule, but to change the backup or maintenance parameters, you must use the DataManager and overwrite one of the tasks.

Delete Existing Schedule

To delete an existing schedule, open the Scheduled Tasks control panel as mentioned above. Right click on the task and choose Delete.