The ca_restore command includes the following SQL Server database options:
ca_restore -source -tape -session [-group] [-tapesessionpw] -dest [<hostname>] [-username <username> -password <password>] -database SQL <Instance name> [SQLServer agent options]
SQLServer agent options:
[[-sql_filegroup <filegroupname>[[-partial_restore] | [[-sql_file <filename>]...[-sql_file <filename>]]]] | [-autorepair_online] | [-autorepair_offline]][-force_replace_exist] [-sql_stopat [-time <timestamp>|-at_mark <markname> [-after <timestamp>]|-before _mark <markname> [-after <timestamp>]]] [-sql_db_op | -sql_db_noop | -sql_db_readonly [<undo_filename>]] [-sql_dbcc <-sql_after|-sql_before> [-physical_only] [-no_indexes]] [-sql_restrict_access] [-sql_keep_replication] [-sql_move_rule [[db]|[fg <filegroup name>][[-drive <drive name>]|[-path <path>]]...]] [-sql_move_rule [file <filegroup name> <file name> [[[-drive <drive name>]|[-path <path name>]|[-name <file name>]]…|[-location <target location>]]]] [-sql_move_rule [sql_transactionlog [[-drive <drive name>]|[-path <path name>]]…]] [-sql_move_rule [sql_transactionlog <log file name> [[[-drive <drive name>]|[-path <path name>]|[-name <file name>]]...|[-location <target location>]]]] [-sql_auto_off] [-sql_forcenp] [-sql_continue_after_checksum_failed]
Note: The ca_restore database options are described in a separate topic titled "Database Options" and can be viewed from the actual CLI by entering the following command: ca_restore allusage.
Specifies the filegroups in the session to be restored.
Specifies the files in the session to be restored.
Specifies to perform a Partial Restore.
Specifies to automatically repair damaged pages in the data files and leaves the database in an online state.
Note: Applies to SQL2005 only.
Specifies to automatically repair damaged pages in data files and leaves the database in an offline state.
Note: Applies to SQL2005 only.
Specifies to perform a Force Restore over existing files.
Specifies to restore the database to the state it was in at a specified event (time or mark).
Specifies to recover the database to the specified date and time. Microsoft SQL Server restores the record in each transaction log backup containing the start and finish time of the backup and then searches this record for the time you have specified.
This is the default option.
Specifies to stop the recovery at the specified mark. This option will recover the database to the specified log mark, including the transaction that contains the mark. If you do not include the -after option, the recovery will stop at the first mark with the specified name. If you include the -after option, the recovery will stop at the first mark with the specified name exactly at or after the date and time.
Mark names apply to log marks, which are specific to transaction logs and do not apply to files/file group restores.
Specifies to stop the recovery before log mark. This option will recover the database to the specified mark, but does not include the transaction that contains the mark. If you do not include the -after option, the recovery will stop at the first mark with the specified name. If you do include the -after option, the recovery will stop at the first mark with the specified name exactly at or after the date and time.
Mark names apply to log marks, which are specific to transaction logs and do not apply to files/file group restores.
Specifies to stop the recovery after the specified date and time mark. The recovery stops at the specified mark only when the timestamp for the log mark is later than the specified time.
Use this option with the -at_mark or -before_mark options.
Specifies to leave the database operational and no additional transaction logs can be restored. This option instructs the restore operation to roll back any uncommitted transactions. After the recovery process, the database is ready for use and additional restores can be performed.
Specifies to leave the database nonoperational, but able to restore additional transaction logs: This option instructs the restore operation not to roll back any uncommitted transactions. You must choose either this option or the leave database read-only option to apply another differential backup or Transaction log.
Specifies to leave the database in a read-only mode and able to restore additional transaction logs.
Undo Filenames are for restores that leave the database in a read-only state.
Specifies to perform a database consistency check (DBCC).
Specifies to perform a DBCC after the restore of the database.
Specifies to perform a DBCC before the restore of the database.
Specifies to check only the physical consistency of the database to verify the structural integrity of all the objects in the database.
Specifies to check the database for consistency without checking indexes for user-defined tables.
Specifies to restrict user access to a newly restored database to members of the db_owner, dbcreator, or sysadmin roles.
Specifies to preserve the replication settings when restoring a published database to a server other than the one on which it was created.
Specifies to move the database.
Specifies that the move rules will be applied to the entire database.
Specifies that the move rules will be applied to the files in the specified filegroup.
Specifies that the move rules will be applied to the specified file.
Specifies that the move rules will be applied to the transactionlog filegroup. If the <log_filename> is specified, the move rules will be applied to the specified log file.
Specifies the target drive for the moved files.
Specifies the target path for moved files, such as:
sqlserver\restoreddata.
Specifies the target file name for specified moved file.
Specifies the target location for the specified moved file. The value of the <target location> parameter should include the drive name, path name, and file name, such as:
c:\sqlserver\restoreddata\log.ldf.
Specifies to turn off the automatic session dependency selection and allow manual selection of the restore options.
The automatic selection option automatically selects:
The automatic selection option is the default option for every restore job
Specifies to use named pipes protocol.
Note: Applies to SQL2000 and prior versions only.
Specifies to continue with the restore job after a checksum failure.
Note: Applies to SQL2005 only.
|
Copyright © 2017
|
|