BackupDirectory Property
The BackupDirectory property specifies the backup directory.
Applies To
| Registry2 Object |
Syntax
object.BackupDirectory [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
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);
Remarks
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 2000 stores backup files in the C:\Program Files\Microsoft SQL Server\Mssql\Backup directory. By default, a named instance of SQL Server 2000 stores backup files in the C:\Program Files\Microsoft SQL Server\Mssql$InstanceName\Backup directory, where InstanceName is the name of a non-default instance of SQL Server.
Note BackupDirectory can be used with Microsoft® SQL Server™ 2000 and SQL Server version 7.0.