The DatabaseFiles property identifies operating system files storing table or index data as targets of a backup or restore operation.
Backup Object | Restore Object |
object.DatabaseFiles [= value]
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list |
value | SQL-DMO multistring identifying one or more operating system files by logical name |
Setting DatabaseFiles directs backup or restore processing to include only those operating system files listed. To specify an operating system file, use its logical name as visible to Microsoft® SQL Server™, not its physical or operating system name.
Set DatabaseFiles to an empty string to reset processing and target the entire database.
String
Read/write
HRESULT GetDatabaseFiles(SQLDMO_LPBSTR pRetVal);
HRESULT SetDatabaseFiles(SQLDMO_LPCSTR NewValue);
Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.