TechNet
Export (0) Print
Expand All

RestoreOptions Properties

 

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

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.

Return to top
Show:
© 2016 Microsoft