Freigeben über


BackupDirectory Property

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The BackupDirectory property specifies the backup directory.

Syntax

object.BackupDirectory [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A string that specifies the backup directory path

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetBackupDirectory(SQLDMO_LPBSTR pRetVal);
HRESULT SetBackupDirectory(SQLDMO_LPCSTR NewValue);

Hinweise

Use the BackupDirectory property to specify a location other than the default directory location when running multiple instances of Microsoft SQL Server.

By default, the default instance of SQL Server stores backup files in the C:\Program Files\Microsoft SQL Server\Mssql\Backup directory. By default, a named instance of SQL Server stores backup files in the C:\Program Files\Microsoft SQL Server\Mssql$InstanceName\Backup directory, where InstanceName is the name of a nondefault instance of SQL Server.

Note   BackupDirectory can be used with Microsoft SQL Server 7.0 and later.

Applies To: