Restore Properties

Restore Properties

 

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

NameDescription
System_CAPS_pubpropertyAction

Gets or sets the type of restore to be performed.

System_CAPS_pubpropertyAsyncStatus

Gets the asynchronous status of a backup or restore process.(Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyBlockSize

Gets or sets the physical block size of the backup or restore, in bytes. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyBufferCount

Gets or sets the total number of I/O buffers to be used for the backup or restore operation. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyChecksum

Gets or sets a Boolean property value that determines whether a checksum value is calculated during backup or restore operations. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyClearSuspectPageTableAfterRestore

Gets or sets a Boolean value that determines whether entries in the suspect page table will be deleted following the restore operation.

System_CAPS_pubpropertyContinueAfterError

Gets or sets a Boolean property value that determines whether the backup or restore continues after a checksum error occurs. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyCredentialName

Gets or sets the Credential property value, which is used to authenticate to the Windows Azure storage account.(Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyDatabase

Gets or sets the database on which the backup or restore operation runs. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyDatabaseFileGroups

Gets the SQL Server file groups targeted by the backup or restore operation. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyDatabaseFiles

Gets the operating system files targeted by the backup or restore operation. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyDatabasePages

Gets the list of the restore pages.

System_CAPS_pubpropertyDevices

Gets the backup devices specified for the backup or restore operation. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyFileNumber

Gets or sets the index number used to identify the targeted backup set on the backup medium.

System_CAPS_pubpropertyKeepReplication

Gets or sets a Boolean property value that specifies whether to maintain a replication configuration during a restore operation.

System_CAPS_pubpropertyMaxTransferSize

Gets or sets the maximum number of bytes to be transferred between the backup media and the instance of SQL Server. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyMediaName

Gets or sets the name used to identify a particular media set. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyNoRecovery

Gets or sets a Boolean property value that determines whether the tail of the log is backed up and whether the database is restored into the Restoring state. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyNoRewind

Gets or sets a Boolean property value that determines whether Microsoft SQL Server will keep the tape open after the backup or restore operation. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyOffset

Gets or sets the array of page addresses to be restored.

System_CAPS_pubpropertyPartial

Gets or sets a Boolean property value that specifies whether a partial or full restore operation will be performed.

System_CAPS_pubpropertyPercentCompleteNotification

Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyRelocateFiles

Gets the array of database logical file names and operating system physical file names used to redirect database storage when a database is restored to a new physical location.

System_CAPS_pubpropertyReplaceDatabase

Gets or sets a Boolean value that specifies whether a restore operation creates a new image of the restored database.

System_CAPS_pubpropertyRestart

Gets or sets a Boolean property value that determines whether the backup or restore operation will restart if it is interrupted. (Inherited from BackupRestoreBase.)

System_CAPS_pubpropertyRestrictedUser

Gets or sets a Boolean property value that specifies whether access to the restored database is restricted to members of the db_owner fixed database role and the dbcreator and sysadmin fixed server roles.

System_CAPS_pubpropertyStandbyFile

Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.

System_CAPS_pubpropertyStopAtMarkAfterDate

Gets or sets the date to be used in conjunction with the mark name specified by StopAtMarkName to determine the stopping point of the recovery operation.

System_CAPS_pubpropertyStopAtMarkName

Gets or sets the mark name to be used in conjunction with the date specified by StopAtMarkAfterDate to determine the stopping point of the recovery operation.

System_CAPS_pubpropertyStopBeforeMarkAfterDate

Gets or sets the date to be used in conjunction with the mark name specified by StopBeforeMarkName to determine the stopping point of the recovery operation.

System_CAPS_pubpropertyStopBeforeMarkName

Gets or sets the mark name to be used in conjunction with the date specified by StopBeforeMarkAfterDate to determine the stopping point of the recovery operation.

System_CAPS_pubpropertyToPointInTime

Gets or sets the endpoint for database log restoration.

System_CAPS_pubpropertyUnloadTapeAfter

Gets or sets a Boolean property value that determines whether tape media are rewound and unloaded after the backup or restore operation completes. (Inherited from BackupRestoreBase.)

Return to top
Show:
© 2016 Microsoft