RestoreOptions Class
SQL Server 2012
Represents the restore options.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
The RestoreOptions type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | Blocksize | Specifies the physical block size, in bytes. |
![]() | BufferCount | Specifies the total number of I/O buffers to be used for the restore operation. |
![]() | ClearSuspectPageTableAfterRestore | Gets or sets whether to delete entries in the suspect page table after restore. |
![]() | ContinueAfterError | Gets or sets whether the restore operation is to continue after an error is encountered. |
![]() | 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. |
![]() | MaxTransferSize | Gets or sets the largest unit of transfer in bytes to be used between the backup media and SQL Server. |
![]() | PercentCompleteNotification | Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls for individual Restore Operations. |
![]() | RecoveryState | Gets or sets the recovery state. |
![]() | 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 |
![]() | SetRestrictedUser | Gets or sets whether to restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles. |
![]() | StandByFile | Undo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed. |

.gif?cs-save-lang=1&cs-lang=fsharp)
.gif?cs-save-lang=1&cs-lang=fsharp)
.gif?cs-save-lang=1&cs-lang=fsharp)