RestoreOptions Class

Represents the restore options.


Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

public class RestoreOptions

The RestoreOptions type exposes the following members.

Public methodRestoreOptionsInitializes a new instance of the RestoreOptions class.

Public propertyBlocksizeSpecifies the physical block size, in bytes.
Public propertyBufferCountSpecifies the total number of I/O buffers to be used for the restore operation.
Public propertyClearSuspectPageTableAfterRestoreGets or sets whether to delete entries in the suspect page table after restore.
Public propertyContinueAfterErrorGets or sets whether the restore operation is to continue after an error is encountered.
Public propertyKeepReplicationGets 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 propertyMaxTransferSizeGets or sets the largest unit of transfer in bytes to be used between the backup media and SQL Server.
Public propertyPercentCompleteNotificationGets or sets the percentage interval for PercentCompleteEventHandler event handler calls for individual Restore Operations.
Public propertyRecoveryStateGets or sets the recovery state.
Public propertyReplaceDatabaseGets or sets SQL Server should create the specified database and its related files even if another database already exists with the same name
Public propertySetRestrictedUserGets or sets whether to restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.
Public propertyStandByFileUndo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed.

Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions