• Article

BackupDirectory Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The BackupDirectory property specifies the backup directory.

Syntaxe

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);

Notes

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:

Registry2 Object