Delen via


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)

Syntax

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

value = instance.ToPointInTime

instance.ToPointInTime = value
public string ToPointInTime { get; set; }
public:
property String^ ToPointInTime {
    String^ get ();
    void set (String^ value);
}
member ToPointInTime : string with get, set
function get ToPointInTime () : String 
function set ToPointInTime (value : String)

Property Value

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

Remarks

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

Examples

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"

See Also

Reference

Restore Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

Back Up and Restore of SQL Server Databases