Technology of SQL Server database (104)
Tuesday, March 03, 2009 by rain
15.5.1 uses Enterprise Manager to restore a database
The operation move that uses SQL Server Enterprise Manager to restore a database is as follows:
(1) the SQL Server Enterprise Manager that start,Click the database server that should login,Choose Tools from inside entree sheet next,In Restore Database of the choice in menu,Shoot a Restoredatabase dialog box,The 15-15 that be like a graph is shown.
(2) the database that next in drawing list choices beside Restore As Database should restore.
(3) select corresponding database backup kind in Restore group through clicking sheet to choose pushbutton.
(4) in Parameters column,Databases of next the choice in drawing list beside Show Backup Of Database,If this database had carried out backup,Can show backup history in form dialog box so.Should use which backup to restore a database from next in drawing list choices by First Backup To Restore,Recent backup is used below default circumstance.
(5) label of pitch on Option,The setting that has other option sees graph 15-16,Among them each option meaning is as follows:Eject Tapes After Restoring Each Backup
Express to finish the tape when restoring to be exited automatically from inside the magetic tape station in backup.Prompt Before Restoring Each Backup
Express advanced after a backup is loaded successfully,Before next backup is loaded, clew restores to operate executant.Force Restore Over Existing Database
Express to enclothe the database file that already existed currently automatically.Restore Database Files As
The position that the row of Restore As in passing reseau is regaining file of the change in the process.Recovery Completion State Frame
The position that the database leaves after expressing to restoring a process to finish,And the database can stand use namely.Leave Database Operational
Express to finish all (database and clerical log) restore.Leave Database Non-operational But Able To Restore Additional Transaction Logs
Express to did not restore clerical log,Accordingly the database can be not used,This option is used below the case that undertakes ability restores database or clerical log for many times.But option of Leave Database Operational should choose when loading final clerical log.Leave Database Read-only and Able To Restore Additional Transaction
Logs is used at on call server (6) after installing option,Click affirmatory pushbutton database to begin to undertake resumptive.
15.5.2RESTORE command undertakes resumptive
1 uses RESTORE command to restore a database
Among them:DBO_ONLY
Express will new the visit attributive of resumptive database awards a database only possessory.FILE
That backup subclass in expressing to restore to have the backup medium of many backup subclass.MEDIANAME
The backup medium name that expresses to use when backup.If give out this option,Check its to whether match with photograph of name of the input when backup above all when restore,If not identical restore an operation to will end.MOVE
The some position that states the database file of a backup restores a system.The position when backup restoring below default condition.NORECOVERY
Express to restore an operation to be not answered roll any general affairs that did not refer.If restore some database,log of many general affairs will restore again after backup,Or many RESTORE are carried out to command in resuming a course,Must use this option of the other outside asking to command except last RESTORE.RECOVERY
Express to roll all general affairs that did not refer.After restoring to end,The database can be used.STANDBY
The UNDO file that states the database restores to operate.
Notice:If do not appoint NORECOVERY, RECOVERY, STANDBY to acquiesce,be RECOVERY.
If the database restores to operate,clerical log should make restore again after the end,Must use NORECOVERY or STANDBY option.REPLACE
The database name that if restore,represents,With the some database that already existed,Heavy name deletes former database to be founded afresh next above all.RESTART
Express from restore to interrupt be in proceed to restore to handle,This option can be used at tape medium only and cross many tape.STOPAT
Express to regain the database the position before this set time,Just can be restored in the clerical log before this time only.If used NORECOVERY or STANDBY option,Criterion cannot make choice of this option.
Database of 15.5.3 part restores
In applying an environment actually,The user often divides database attaint to for instance one is expressed or index because of be operated by accident and bringing about a ministry.The share that SQL Server offers new mechanism to occupy a library in order to realize logarithm restores,Thereby endamage or missing data copy primitive database afresh.For example,If the user deletes a piece of watch erroneously,That part database that you can restore to include this to delete a watch only.The condition when log or difference backup can restore the watch to be deleted to its.Below the following circumstance we can discover partial database restores to have huge value.
To make develop or generating forms for reporting statistics to be able to be in a subclass of some database is founded on the server additionally;
Restore to file data.
Team of file of service data library wants when undertaking partial database restores to operate,And always should restore main file and file group,It is to restore the corresponding database file that you appoint or file group in addition.
The syntactic regulation that command of use RESTORE has partial database restores is: