Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Database log restoration with undo is available against a read-only image of a SQL Server database and offers one strategy for maintaining a standby image of critical instances.
The following code example sets the location of a backup file that can be used as an undo file for the database restore operation.
Dim rs As Restore rs = New Restore rs.StandbyFile = "C:\AdventureWorks2012Backup.bak"
$rs = new-object Microsoft.SqlServer.Management.Smo.Restore $rs.StandbyFile = "C:\AdventureWorks2012Backup.bak"