備份與恢復ppt課件-資料下載頁
2025-04-28 23:43本頁面
【正文】 39。operating_system_file_name39。 ] [ ,...n ] [ [ , ] NORECOVERY ] [ [ , ] REPLACE ] ] backup_device ::= { { logical_backup_device_name } | { DISK | TAPE } = { 39。physical_backup_device_name39。 } } files_or_filegroups ::= { FILE = logical_file_name | FILEGROUP = logical_filegroup_name } 3．文件還原或頁面還原 文件還原或頁面還原的語法格式如下： RESTORE DATABASE database_name file_or_filegroup [ ,...f ] [ FROM backup_device [ ,...n ] ] [ WITH [ FILE = file_number ] [ [ , ] MOVE 39。logical_file_name39。 TO 39。operating_system_file_name39。 ] [ ,...n ] [ [ , ] NORECOVERY ] [ [ , ] REPLACE ] ] backup_device ::= { { logical_backup_device_name } | { DISK | TAPE } = { 39。physical_backup_device_name39。 } } file_or_filegroup ::= { FILE = logical_file_name | FILEGROUP = logical_filegroup_name } 4．事務日志還原 事務日志還原的語法格式如下： RESTORE LOG database_name [ file_or_filegroup [ ,...f ] ] [ FROM backup_device [ ,...n ] ] [ WITH [ FILE = file_number ] [ [ , ] MOVE 39。logical_file_name39。 TO 39。operating_system_file_name39。 ] [ ,...n ] [ [ , ] { RECOVERY | NORECOVERY | STANDBY = standby_file_name }] [ [ , ] REPLACE ] ] backup_device ::= { { logical_backup_device_name } | { DISK | TAPE } = { 39。physical_backup_device_name39。 } } file_or_filegroup ::= { FILE = logical_file_name | FILEGROUP = logical_filegroup_name
教學課件相關推薦
鄂ICP備17016276號-1