Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
RestoreOptions Properties

RestoreOptions Properties

The RestoreOptions type exposes the following members.

  Name Description
Public property Blocksize Specifies the physical block size, in bytes.
Public property BufferCount Specifies the total number of I/O buffers to be used for the restore operation.
Public property ClearSuspectPageTableAfterRestore Gets or sets whether to delete entries in the suspect page table after restore.
Public property ContinueAfterError Gets or sets whether the restore operation is to continue after an error is encountered.
Public property KeepReplication Gets or sets whether to prevent replication settings from being removed when a database backup or log backup is restored on a warm standby server and the database is recovered.
Public property MaxTransferSize Gets or sets the largest unit of transfer in bytes to be used between the backup media and SQL Server.
Public property PercentCompleteNotification Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls for individual Restore Operations.
Public property RecoveryState Gets or sets the recovery state.
Public property ReplaceDatabase Gets or sets SQL Server should create the specified database and its related files even if another database already exists with the same name
Public property SetRestrictedUser Gets or sets whether to restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.
Public property StandByFile Undo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed.

Community Additions

© 2015 Microsoft