|
|
|
|
Restore SQL Server
Normal Setting
Backup Set Selection
Advance Options
E-Mail Notification
Normal Setting
Job name : The name of the restore job .
Database : The database you want to restore , it only list the databases you have backed up.
Restore From : Specify where the backup set are save.
Local Machine / Network Shares .
If the backup sets are in local machine or Network shares , please select this option , in this case . Please note that , if the destination directory is a network shared folder , you should have the read privilege on that machine.
Remote Server .
If the backup sets are on a remote machine , please use this option .
Server Setting
If restore database from remote machine ,you should specify who can connect to the data server , and keep Data Server running when the backup job is begin to run . All account are added in "Storage Manager" program.
Backup Set Selection
Select : Select a backup set in list view to restore database.
Clear: Clear all selection.
Auto select the backup set : If you select this option , it will select the latest backup set to restore database.
Location : Location display in the list view is get from backup record , if the backup set is not locate in that directory , you can change the location use this button.
Advance Options
Restore database with a new database name : If you want to restore database use another name , select this option . If this option is selected , the "Restore files to new location" option should also be selected .
Replace existing database and its related files:
Specifies that SQL Server should create the specified database and its related files even if another database already exists with the same name. In such a case, the existing database is deleted. When the REPLACE option is not specified, a safety check occurs (which prevents overwriting a different database on accident). The safety check ensures that the RESTORE DATABASE statement will not restore the database to the current server if:
The database named in the RESTORE statement already exists on the current server, and
Either the database name is different from the database name recorded in the backup set or the set of files in the database is different from the set of database files contained in the backup set. Differences in file size are ignored.
The option allows overwriting of an existing file, which is useful only when attempting to restore a file on a disk that is replacing a failed disk.
Restore files to a new location : By default, the logical file name is restored to its original location ,but if you want to restore to a new location , you can change the location by clicking the "New Location" button. The name rule for database files recommended by Microsoft is
[ Directory ]+[ Logical Name ] + ".mdb" for data file and [ Directory ]+[ Logical Name ] + "_log.ldf" for log file.
E-Mail Notification
Use E-Mail Notification
If you want SQL Server Backup send you an e-mail to let you know the job status , just select this option.
Outgoing Mail Server Setting
Mail Server : The SMTP server that send the mail.
Port . The port that mail server use. Most mail server use the 25 port.
Account : The account that login to the mail server .
Password : The password that use to login to mail server.
E-Mail Setting
Send To : The mail box that receive the notification mail.
CC : Mail box that copy this mail to.
Subject : Subject of the notification mail . If you keep the field is "" , the subject will appear as "jobname + start date time + Job Status ". If you want to change the subject , just fill the text you want .
Sender : The outgoing mail box .
Attached with Log file : Log file will be created during the job running stage .it will send you as attachment of the mail if you check this box..
|
|
|
Home