SQLServer 还原语法

摘自SQLServer联机手册

语法

 

--To Restore an Entire Database from a Full database backup (a Complete Restore):RESTORE DATABASE { database_name | @database_name_var }  [ FROM <backup_device> [ ,...n ] ] [ WITH    {        [ RECOVERY | NORECOVERY | STANDBY =         {standby_file_name | @standby_file_name_var }        ]    | ,  <general_WITH_options> [ ,...n ]      | , <replication_WITH_option>   | , <change_data_capture_WITH_option>      | , <service_broker_WITH options>       | , <point_in_time_WITH_options—RESTORE_DATABASE>       } [ ,...n ] ][;]

 

--To perform the first step of the initial restore sequence-- of a piecemeal restore:RESTORE DATABASE { database_name | @database_name_var }    <files_or_filegroups> [ ,...n ] [ FROM <backup_device> [ ,...n ] ]    WITH       PARTIAL, NORECOVERY       [  , <general_WITH_options> [ ,...n ]        | , <point_in_time_WITH_options—RESTORE_DATABASE>       ] [ ,...n ] [;]

 

--To Restore Specific Files or Filegroups: RESTORE DATABASE { database_name | @database_name_var }    <file_or_filegroup> [ ,...n ] [ FROM <backup_device> [ ,...n ] ]    WITH    {      [ RECOVERY | NORECOVERY ]      [ , <general_WITH_options> [ ,...n ] ]      } [ ,...n ] [;]

 

--To Restore Specific Pages: RESTORE DATABASE { database_name | @database_name_var }    PAGE = 'file:page [ ,...n ]'   [ , <file_or_filegroups> ] [ ,...n ] [ FROM <backup_device> [ ,...n ] ]    WITH           NORECOVERY               [ , <general_WITH_options> [ ,...n ] ][;]

 

--To Restore a Transaction Log:RESTORE LOG { database_name | @database_name_var }  [ <file_or_filegroup_or_pages> [ ,...n ] ] [ FROM <backup_device> [ ,...n ] ]  [ WITH    {     [ RECOVERY | NORECOVERY | STANDBY =         {standby_file_name | @standby_file_name_var }        ]    | ,  <general_WITH_options> [ ,...n ]    | , <replication_WITH_option>        | , <point_in_time_WITH_options—RESTORE_LOG>       } [ ,...n ] ] [;]

 

--To Revert a Database to a Database Snapshot:   RESTORE DATABASE { database_name | @database_name_var } FROM DATABASE_SNAPSHOT = database_snapshot_name 

 

<backup_device>::={    { logical_backup_device_name |            @logical_backup_device_name_var } | { DISK | TAPE } = { 'physical_backup_device_name' |            @physical_backup_device_name_var } } <files_or_filegroups>::= {    FILE = { logical_file_name_in_backup | @logical_file_name_in_backup_var }  | FILEGROUP = { logical_filegroup_name | @logical_filegroup_name_var }  | READ_WRITE_FILEGROUPS} 

 

<general_WITH_options> [ ,...n ]::= --Restore Operation Options   MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'           [ ,...n ]  | REPLACE  | RESTART  | RESTRICTED_USER --Backup Set Options | FILE = { backup_set_file_number | @backup_set_file_number }  | PASSWORD = { password | @password_variable } --Media Set Options | MEDIANAME = { media_name | @media_name_variable }  | MEDIAPASSWORD = { mediapassword | @mediapassword_variable }  | BLOCKSIZE = { blocksize | @blocksize_variable } --Data Transfer Options | BUFFERCOUNT = { buffercount | @buffercount_variable }  | MAXTRANSFERSIZE = { maxtransfersize | @maxtransfersize_variable }--Error Management Options | { CHECKSUM | NO_CHECKSUM }  | { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } --Monitoring Options | STATS [ = percentage ] --Tape Options | { REWIND | NOREWIND }  | { UNLOAD | NOUNLOAD } <replication_WITH_option>::= | KEEP_REPLICATION <change_data_capture_WITH_option>::= | KEEP_CDC<service_broker_WITH_options>::=  | ENABLE_BROKER  | ERROR_BROKER_CONVERSATIONS  | NEW_BROKER <point_in_time_WITH_options—RESTORE_DATABASE>::=  | {     STOPAT = { 'datetime' | @datetime_var }   | STOPATMARK = { 'lsn:lsn_number' }                 [ AFTER 'datetime' ]  | STOPBEFOREMARK = {  'lsn:lsn_number' }                 [ AFTER 'datetime' ]       } <point_in_time_WITH_options—RESTORE_LOG>::=  | {      STOPAT = { 'datetime' | @datetime_var }   | STOPATMARK = { 'mark_name' | 'lsn:lsn_number' }                 [ AFTER 'datetime' ]  | STOPBEFOREMARK = { 'mark_name' | 'lsn:lsn_number' }                 [ AFTER 'datetime' ]       }