Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

BackupRestoreBase.NoRewind Property


Applies To: SQL Server 2016 Preview

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

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

public bool NoRewind { get; set; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the tape is rewound at the end of the operation or not.

If True, the tape drive is open and positioned.

If False (default), the tape is rewound

When NoRewind property is set to True, SQL Server will keep a tape drive open and positioned, thereby preventing the overhead of rewinding and scanning a tape. This is useful in situations where a tape is repeatedly used.

Return to top
© 2015 Microsoft