This topic has not yet been rated - Rate this topic

Backup.FormatMedia Property

SQL Server 2008

Gets or sets a Boolean property value that determines whether a tape is formatted as the first step of the backup operation.

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

Syntax

C++

JScript

public bool FormatMedia { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the tape will be formatted.
If True, the Microsoft SQL Server backup operation attempts to format the tape as the initial step.
If False (default), the SQL Server backup operation does not attempt to format the tape.

Remarks

The FormatMedia property applies only when the backup medium is tape. The property has no meaning for device, file, or pipe media.

Examples

Backing Up and Restoring Databases and Transaction Logs

Reference

Backup Class

Backup Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

BACKUP (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD