Database Maintenance Tasks

The following sections provided detailed instructions for scheduling and performing routine SunLink Server database maintenance tasks. You complete most of the tasks by using the SunLink Server Manager tool; however, some of the tasks require that you use the SunLink Server command line.

How to Clean up SunLink Server Databases

1. Using SunLink Server Manager, log on to and then open the SunLink Server computer on which you want to clean up one or more databases.

2. In the results pane, double-click "Tasks" and then double-click "Clean Up Databases."

The resulting screen presents a list of databases to clean up.

The Cleanup wizard performs the following tasks on the following databases:

3. Choose all of the databases that you want to clean up, then click Next.

4. Click Finish.

The resulting screen follows the progress of the cleanup, indicating a completed task with a checkmark and a pending task with an arrow.

How to Back up SunLink Server Databases

1. Using SunLink Server Manager, log on to and then open the SunLink Server computer on which you want to back up one or more databases.

2. In the results pane, double-click "Tasks" and then double-click "Back Up and Restore Databases."

The resulting screen presents backup and restore options.

3. Select "Back up one or more SunLink Server databases," and then click Next.

The resulting screen presents a list of databases that you can back up, and includes a text field in which you specify the path to your database backup file. Note that your backup file must be stored as a Solaris file in an existing directory on the SunLink Server system, rather than locally.

4. Select all of the databases that you want to back up, specify the backup file's path name (either a directory or a device), and then click Next.

The resulting screen enables you to specify how you want the Database Backup and Restore wizard to handle server shutdown and startup.

Note that the server must be shut down each time the wizard runs a maintenance task. If you do not choose the option to "Allow Database Backup and Restore to stop processes," you will be unable to continue the backup task. If you do choose to have the wizard automatically shut down the SunLink Server processes for maintenance, then you will also be able to specify that the wizard restarts the server after the tasks are completed.

5. Choose how you want the Database Backup and Restore wizard to handle server shutdown and startup, then click Finish.

The resulting screen follows the progress of the cleanup, indicating a completed task with a checkmark and a pending task with an arrow.

 

How to Restore Backed-Up Databases

1. Using SunLink Server Manager, log on to and then open the SunLink Server computer on which you want to restore one or more backed-up databases.

2. In the results pane, double-click "Tasks" and then double-click "Back Up and Restore Databases."

The resulting screen presents backup and restore options.

3. Select "Restore one or more SunLink Server databases," and then click Next.

The resulting screen presents a text field in which you specify the path to the database backup file that you want to restore.

4. Enter the path name of the backup file, and then click Next.

The resulting screen presents a list of databases that you can restore.

5. Select all of the backed-up database files that you want to restore, and then click Next.

The resulting screen enables you to specify how you want the Database Backup and Restore wizard to handle server shutdown and startup.

Note that the server must be shut down each time the wizard runs a maintenance task. If you do not choose the option to "Allow Database Backup and Restore to stop processes," you will be unable to continue with database restoration. If you do choose to have the wizard automatically shut down the SunLink Server processes for maintenance, then you will also be able to specify that the wizard restarts the server after the tasks are completed.

6. Choose how you want the Database Backup and Restore wizard to handle server shutdown and startup, then click Finish.

The resulting screen follows the progress of the cleanup, indicating a completed task with a checkmark and a pending task with an arrow.

How to Create an Automatic Schedule for Both Database Cleanup and Backup

1. Using SunLink Server Manager, log on to and then open the SunLink Server computer on which you want to schedule maintenance tasks.

2. In the results pane, double-click "Tasks" and then double-click "Schedule Database Maintenance."

The resulting screen presents both the cleanup and backup options:

3. Choose one or both maintenance options (selected by default), then click Next.

(Depending on whether you chose one or both tasks, one of the following screens may not be displayed.) The resulting screen presents a list of databases to clean up automatically.

4. Choose all of the databases that you want to clean up, then click Next.

The resulting screen presents a list of databases to back up automatically, and includes a text field in which you specify the path to your database backup file. Note that your backup file must be stored as a Solaris file in an existing directory on the SunLink Server system, rather than locally.

5. Choose all of the databases that you want to back up, specify the backup file's path name, and then click Next.

The resulting screen enables you to specify how you want the Database Maintenance wizard to handle server shutdown and startup.

Note that the server must be shut down each time the wizard runs a maintenance task. If you do not choose the option to "Allow the Maintenance wizard to stop processes," you will be unable to continue scheduling the maintenance tasks. If you do choose to have the Maintenance wizard automatically shut down the SunLink Server processes for maintenance, then you will also be able to specify that the wizard restarts the server after the tasks are completed.

6. Choose how you want the Database Maintenance wizard to handle server shutdown and startup, then click Next.

The resulting screen enables you to specify the frequency of maintenance tasks: one time only, daily, weekly, or monthly. The default is weekly.

7. Select how frequently you want the maintenance tasks to be run, then click Next.

The resulting screen enables you to choose times for the maintenance tasks with greater precision; the options will be different, depending on the frequency you chose:

8. Specify days, dates, and times, and then click Next.

The resulting screen presents a summary of your choices, and gives you another opportunity to amend them.

9. Examine the Maintenance Job Summary, then click Finish to confirm your choices and activate the defined maintenance schedule, or Back to amend any of your choices.

After you have confirmed your choices and scheduled your maintenance tasks, a summary of the scheduled tasks will be presented to you each time you open the Maintenance Task wizard.

Once you have scheduled your maintenance tasks, you can change the schedule--or delete it entirely--at any time. For details, see the next section, How to View, Modify, or Delete Scheduled Database Maintenance Tasks ."

How to View, Modify, or Delete Scheduled Database Maintenance Tasks

1. Using SunLink Server Manager, log on as root to the SunLink Server computer on which you want to schedule maintenance tasks.

2. In the results pane, double-click "Tasks" and then double-click "Schedule Database Maintenance."

The resulting screen presents a summary of the maintenance tasks that have been scheduled:

3. Do one of the following:

4. Click Finish to confirm that you want to delete the specified maintenance task.

How to Compact the WINS Database by Using the SunLink Server Command Line

1. Log on to the SunLink Server WINS computer as root.

2. Stop the WINS server by typing the following command:

net stop wins

3. Compact the WINS database by typing the following command:

winsadm -c

4. Start the WINS server by typing the following command:

net start wins