|
SSDOT Backup
Options for a Pears Database
Keeping at least
one recent copy of a database is the best practice for any database administrator.
SSDOT for Pears provides backup options
for listing, creating, and deleting backup copies of a Pears
database. Additionally, it offers the option to restore a database
from a backup. What follows are the procedures for performing each of
these administrative functions on a Pears
database using SSDOT for Pears.
Contents
List Backups
Delete Backups
Create a Backup
Restore from Backup
List
Backups
To
determine if a current backup exists for a Pears
database, you can list the date and time stamps of all backups. The
following procedure instructs you on how to complete this simple activity
in SSDOT for Pears:
1. Start
SSDOT for Pears.
Result: |
The
following Main Menu appears:
|
Main Menu
1. Database
Registration
2. BER Records
3. Database Creation and Maintenance
4. Database Backup
5. Advanced Options
6. Exit SSDOT
Working Database:
No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
2. Type
4 and press Enter to go to the Database Backup Menu.
Result: |
The
following menu appears:
|
Database Backup
Menu
1. List available backups
2. Delete backup
3. Create backup
4. Restore from backup
5. Exit SSDOT
Working Database: No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
3. Type
1 and press Enter.
Result: |
The
prompt appears:
|
Name of database
or press [ENTER] key to list all backups:
|
4. Type the
name of the database and press Enter.
Result: |
Information
similar to the following appears:
|
marcus:
1. Tuesday, October
23, 2001 10:43:59 AM EDT
2. Tuesday, October 23, 2001 11:18:23 AM EDT
Press [ENTER]
key to continue:
|
5. Press Enter
after you have finished reviewing the backup information to return
to the Database Backup Menu.
|
Return
to Contents
Delete
Backups
It
is not necessary for you to keep multiple backup copies of each database,
especially out-of-date copies. In fact the best practice is to delete
older versions of backups immediately after you have created a new backup
in order to conserve your file space and avoid confusion about which backup
copy to use when recovering a database. To delete old backup copies of
Pears database files using SSDOT
for Pears, complete the following steps:
1. Start
SSDOT for Pears.
Result: |
The
following Main Menu appears:
|
Main Menu
1. Database
Registration
2. BER Records
3. Database Creation and Maintenance
4. Database Backup
5. Advanced Options
6. Exit SSDOT
Working Database:
No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
2. Type
4 and press Enter to go to the Database Backup Menu.
Result: |
The
following menu appears:
|
Database Backup
Menu
1. List available backups
2. Delete backup
3. Create backup
4. Restore from backup
5. Exit SSDOT
Working Database: No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
3. Type
2 and press Enter.
Result: |
The
following prompt appears:
|
Name of database
or press [ENTER] key to return to menu:
|
4. Type the
name of the database and press Enter.
Example: |
|
Name
of database or press [ENTER] key to return to menu: marcus |
Result: |
Information
and a prompt similar to the following appear:
|
marcus:
1. Tuesday, October
23, 2001 10:43:59 AM EDT
2. Tuesday, October 23, 2001 11:18:23 AM EDT
Backup number or press [ENTER] key to return to menu:
|
5. Type the
number corresponding to the backup copy that you want to delete
and press Enter.
Example: |
|
marcus:
1. Tuesday,
October 23, 2001 10:43:59 AM EDT
2. Tuesday, October 23, 2001 11:18:23 AM EDT
Backup number or press [ENTER] key to return to menu: 1
|
Result: |
A
prompt similar to the following appears:
|
Backup made on
Tuesday, October 23, 2001 10:43:59 AM EDT successfully deleted.
Press [ENTER]
key to continue:
|
6. Press Enter
to return to the Database Backup Menu.
Note: |
Complete
Steps 3 - 6 to delete additional backup copies. |
|
Return
to Contents
Create
a Backup
In order to recover
a Pears database using SSDOT
for Pears, you first need a current backup copy of the database. The
procedure below instructs you on how to create a backup of a Pears
database.
1. Start
SSDOT for Pears.
Result: |
The
following Main Menu appears:
|
Main Menu
1. Database
Registration
2. BER Records
3. Database Creation and Maintenance
4. Database Backup
5. Advanced Options
6. Exit SSDOT
Working Database:
No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
2. Type
4 and press Enter to go to the Database Backup Menu.
Result: |
The
following menu appears:
|
Database Backup
Menu
1. List available backups
2. Delete backup
3. Create backup
4. Restore from backup
5. Exit SSDOT
Working Database: No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
3. Type
3 and press Enter.
Result: |
The
following prompt appears:
|
**WARNING: The
database will be locked down and unavailable during the backup process.**
Press [ENTER] key to continue or type "q" to quit:
|
4. Press Enter
to continue the backup procedure.
Result: |
The
following prompt appears:
|
Name of database
or press [ENTER] key to return to menu:
|
5. Type the
name of the database and press Enter.
Example: |
|
Name of
database or press [ENTER] key to return to menu: marcus
|
Result: |
A
prompt similar to the following appears:
|
Working, please
wait ||||||
Database marcus was backed up successfully on Tuesday, October 23,
2001 12:28:23 PM EDT.
Press [ENTER]
key to continue:
|
6. Press Enter
to return to the Database Backup Menu.
|
Return
to Contents
Restore
from Backup
The chief reason
for maintaining a backup copy of a Pears
database is to use it in recovering the database should it become
corrupted. A backup copy, along with any transaction journal files, can
be used successfully to reinstate a database to its condition just prior
to it becoming corrupted. The procedure below guides you through the typical
recovery of a corrupted Pears database.
1. Start
SSDOT for Pears.
Result: |
The
following Main Menu appears:
|
Main Menu
1. Database
Registration
2. BER Records
3. Database Creation and Maintenance
4. Database Backup
5. Advanced Options
6. Exit SSDOT
Working Database:
No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
2. Type
4 and press Enter to go to the Database Backup Menu.
Result: |
The
following menu appears:
|
Database Backup
Menu
1. List available backups
2. Delete backup
3. Create backup
4. Restore from backup
5. Exit SSDOT
Working Database: No database selected
Type "l"
To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database
Press [ENTER]
key to return to Main Menu
>
|
3. Type
4 and press Enter.
Result: |
The
following prompt appears:
|
**WARNING: The
database will be locked down and unavailable during the backup process.**
Press [ENTER] key to continue or type "q" to quit:
|
4. Press Enter
to continue the recovery procedure.
Result: |
The
following prompt appears:
|
Name of database
or press [ENTER] key to return to menu:
|
5. Type the
name of the database and press Enter.
Example: |
|
Name of
database or press [ENTER] key to return to menu: marcus
|
Result: |
A
prompt similar to the following appears:
|
1. Tuesday, October
23, 2001 12:28:23 PM EDT
2. Tuesday, October 23, 2001 11:18:23 AM EDT
Backup Number or press [ENTER] key to return to menu:
|
6. Type the
number corresponding to the backup copy that you wish to use to
recover the database and press Enter.
Result: |
The
following prompt appears:
|
Restore backup
database description? (yes/no)
|
7. Do you wish
to restore the backup copy of the database
description configuration file?
Result: |
Information
and a prompt similar to the following appear:
|
Database marcus
was restored successfully from backup made on Tuesday, October 23,
2001 12:28:23 PM EDT.
Press [ENTER]
key to continue:
|
Return
to Contents
See Also
Pears
System Overview
Pears-Newton Comparison
Creating a New Pears Database
Pears Database Description Configuration
File
|