4.Provide the [Backup File Name] for the files to backup in [Database Backup]. (Used to backup files manually.)
5.Click [Backup]. (Used to backup files manually.)
6.Specify the backup frequency in [Database Schedule Backup]. (Used to backup files automatically.)
7.Provide the [Schedule Operation Time] in [Database Schedule Backup]. (Used to backup files automatically.)
8.Click [Generation] in [Database Schedule Backup]. (Used to backup files automatically.)
9.Select a file to restore in [Select Backup File] from [Database Restore]. (Used to restore a database.)
10.Click [Restore] in [Database Restore] to start restoring the selected database. (Used to restore a database.)
M The access control data will be saved in the SQL Server 2005 database. To prevent data loss, use this tool or the tool provided by SQL Server 2005 to create a backup file for the database. Backup of a database includes all records of existing data in the database. You can use this page to backup and restore data, or specify the auto backup schedule. In this page, you can also delete unnecessary information in the database. However, the auto backup schedule is managed by the Microsoft SQL Server 2005 agent so the agent must stay active for this purpose.
Provides a description of the Database Backup & Restore screen.
-Database: Displays the names of connected databases.
-Server: Displays the names of connected database servers.
-Login ID: Displays the login ID used to connect to the database.
-The [Database Backup] file path indicates the installation path of a database in other than the local PC, and the backup file name is the name of the file to backup, which you can change manually.
-The [Database Schedule Backup] frequency is one of Every Day, Every Week or Every Month, which you can schedule to run the backup at a specific interval. You can make different settings according to the backup frequency, create up to 3 schedules at once, and specify the schedule operation time differently according to the frequency.
-The [Select Backup File] bar in [Database Restore] specifies the path and name of the backup file to be used in restoring the database in the server installed in other than the local PC.
Provides a description for Manual Backup/Schedule Backup/Restore.
-Database Backup: Specify the backup path and provide the file name; then click [Backup] to create a backup file in the specified location.
-Database Schedule Backup (Every Day): When the backup is completed with the provided information, a backup file named “Access_Daily_Full_yyyymmdd.bak” will be created in that location.
-Database Schedule Backup (Every Week): When the backup is completed with the provided information, a backup file named “Access_Week_Full_yyyymmdd.bak” will be created in that location.
-Database Schedule Backup (Every Monthly): When the backup is completed with the provided information, a backup file named “Access_Month_Full_yyyymmdd.bak” will be created in that location.
-Restore: The [Restore] button will be not be active until you specify a backup file for restoring the database. Specify the backup path and click [OK] to activate the [Restore] button. Click [Restore] to perform restoring the database in the specified backup name.
TOOL