RestoreOptions Class

 

Represents the restore options.

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

System.Object
  Microsoft.SqlServer.Management.Smo.RestoreOptions

Public Class RestoreOptions

NameDescription
System_CAPS_pubmethodRestoreOptions()

Initializes a new instance of the RestoreOptions class.

NameDescription
System_CAPS_pubpropertyBlocksize

Specifies the physical block size, in bytes.

System_CAPS_pubpropertyBufferCount

Specifies the total number of I/O buffers to be used for the restore operation.

System_CAPS_pubpropertyClearSuspectPageTableAfterRestore

Gets or sets whether to delete entries in the suspect page table after restore.

System_CAPS_pubpropertyContinueAfterError

Gets or sets whether the restore operation is to continue after an error is encountered.

System_CAPS_pubpropertyKeepReplication

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.

System_CAPS_pubpropertyMaxTransferSize

Gets or sets the largest unit of transfer in bytes to be used between the backup media and SQL Server.

System_CAPS_pubpropertyPercentCompleteNotification

Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls for individual Restore Operations.

System_CAPS_pubpropertyRecoveryState

Gets or sets the recovery state.

System_CAPS_pubpropertyReplaceDatabase

Gets or sets SQL Server should create the specified database and its related files even if another database already exists with the same name

System_CAPS_pubpropertySetRestrictedUser

Gets or sets whether to restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.

System_CAPS_pubpropertyStandByFile

Undo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed.

NameDescription
System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(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.

Return to top
Show: