Export (0) Print
Expand All

Restore Properties

  Name Description
ms220080.pubproperty(en-US,SQL.90).gif Action
Gets or sets the type of restore to be performed.
ms220080.pubproperty(en-US,SQL.90).gif AsyncStatus 
Gets the asynchronous status of a backup or restore process.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif Checksum 
Gets or sets a Boolean property value that determines whether a checksum value is calculated during backup or restore operations.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif ClearSuspectPageTableAfterRestore
Gets or sets a Boolean value that determines whether entries in the suspect page table will be deleted following the restore operation.
ms220080.pubproperty(en-US,SQL.90).gif ContinueAfterError 
Gets or sets a Boolean property value that determines whether the backup or restore continues after a checksum error occurs.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif Database 
Gets or sets the database on which the backup or restore operation runs.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif DatabaseFileGroups 
Gets the Microsoft SQL Server file groups targeted by the backup or restore operation.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif DatabaseFiles 
Gets the operating system files targeted by the backup or restore operation.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif Devices 
Gets the backup devices specified for the backup or restore operation. This property is not CLS-compliant.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif FileNumber
Gets or sets the index number used to identify the targeted backup set on the backup medium.
ms220080.pubproperty(en-US,SQL.90).gif KeepReplication
Gets or sets a Boolean property value that specifies whether to maintain a replication configuration during a restore operation.
ms220080.pubproperty(en-US,SQL.90).gif MediaName 
Gets or sets the name used to identify a particular media set.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif NoRecovery 
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 )
ms220080.pubproperty(en-US,SQL.90).gif NoRewind 
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 )
ms220080.pubproperty(en-US,SQL.90).gif Offset
Gets or sets the array of page addresses to be restored.
ms220080.pubproperty(en-US,SQL.90).gif Partial
Gets or sets a Boolean property value that specifies whether a partial or full restore operation will be performed.
ms220080.pubproperty(en-US,SQL.90).gif PercentCompleteNotification 
Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif RelocateFiles
Gets or sets 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.
ms220080.pubproperty(en-US,SQL.90).gif ReplaceDatabase
Gets or sets a Boolean value that specifies whether a restore operation creates a new image of the restored database.
ms220080.pubproperty(en-US,SQL.90).gif Restart 
Gets or sets a Boolean property value that determines whether the backup or restore operation will restart if it is interrupted.
(inherited from BackupRestoreBase )
ms220080.pubproperty(en-US,SQL.90).gif RestrictedUser
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.
ms220080.pubproperty(en-US,SQL.90).gif StandbyFile
Gets or sets the name of an undo file used as part of the imaging strategy for a Microsoft SQL Server instance.
ms220080.pubproperty(en-US,SQL.90).gif StopAtMarkAfterDate
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.
ms220080.pubproperty(en-US,SQL.90).gif StopAtMarkName
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.
ms220080.pubproperty(en-US,SQL.90).gif StopBeforeMarkAfterDate
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.
ms220080.pubproperty(en-US,SQL.90).gif StopBeforeMarkName
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.
ms220080.pubproperty(en-US,SQL.90).gif ToPointInTime
Gets or sets the endpoint for database log restoration.
ms220080.pubproperty(en-US,SQL.90).gif UnloadTapeAfter 
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 )

Community Additions

ADD
Show:
© 2014 Microsoft