Export (0) Print
Expand All

Restore.ToPointInTime Property

Gets or sets the endpoint for database log restoration.

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

'Declaration
Public Property ToPointInTime As String 
	Get 
	Set
'Usage
Dim instance As Restore 
Dim value As String 

value = instance.ToPointInTime

instance.ToPointInTime = value

Property Value

Type: String
A string that specifies the date and time values that identify the endpoint.

The ToPointInTime property is evaluated only when using a Restore object to recover a database transaction log.

The following code example sets a date and time at which the restore operation halts.

VB

Dim rs As Restore
rs = New Restore
rs.ToPointInTime = "Apr 15, 2020 12:00 AM"

PowerShell

$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.ToPointInTime = "Apr 15, 2020 12:00 AM"

Community Additions

ADD
Show:
© 2014 Microsoft