Export (0) Print
Expand All

RestoreOptions Class

Represents the restore options.

Object
  Microsoft.SqlServer.Management.Smo.RestoreOptions

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

'Declaration
Public Class RestoreOptions
'Usage
Dim instance As RestoreOptions

The RestoreOptions type exposes the following members.

  NameDescription
Public methodRestoreOptionsInitializes a new instance of the RestoreOptions class.
Top

  NameDescription
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.
Top

  NameDescription
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.)
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft