مشاركة عبر


BackupDevice.PhysicalLocation Property

Gets or sets the path to the device or operating system file that represents the physical backup location.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property PhysicalLocation As String 
    Get 
    Set
'Usage
Dim instance As BackupDevice 
Dim value As String 

value = instance.PhysicalLocation

instance.PhysicalLocation = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
public string PhysicalLocation { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
public:
property String^ PhysicalLocation {
    String^ get ();
    void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
member PhysicalLocation : string with get, set
function get PhysicalLocation () : String 
function set PhysicalLocation (value : String)

Property Value

Type: System.String
A String value that contains the full path to the physical location of the backup device. By default, the value is an empty string.

Remarks

The PhysicalLocation property is a string with a maximum of 260 characters.

Specify an operating system file or tape using a UNC string. For example, the string \\Seattle1\Backups\Northwind.bak specifies a server name, directory, and file name for a backup device. The string \\.\TAPE0 specifies a server and a file device, most likely a tape, as a backup device.

Examples

Backing Up and Restoring Databases and Transaction Logs

See Also

Reference

BackupDevice Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Backup Devices (SQL Server)