SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Properties (SQL-DMO)
D (SQL-DMO Properties)
Database Property
DatabaseFileGroups Property
DatabaseFiles Property
DatabaseName Property
DatabaseUserName Property
DataFile Property
DataFilePath Property
DataFileSize Property
DataFileType Property
DataFolder Property
DataSource Property
DataSpaceUsage Property
DataSpaceUsed Property
Datatype Property
DateCreated Property
DateFindOperand Property
DateJobCreated Property
DateJobLastModified Property
DateLastModified Property
Day Property
Days Property
DboLogin Property
DBOUseOnly Property
DBOwner Property
DBReadOnly Property
Default Property (Column, UserDefinedDatatype)
Default Property (FileGroup)
DefaultCursor Property
DefaultDomain Property
DefaultLogin Property
DefaultOwner Property
DefaultPath Property
DelayBetweenResponses Property
DeleteCommand Property
DeleteLevel Property
DenyNTLogin Property
DestDatabase Property
DestinationObjectName Property
DestinationOwnerName Property
DestLogin Property
DestPassword Property
DestServer Property
DestTranslateChar Property
DestUseTrustedConnection Property
DeviceNumber Property
Devices Property
DistributionAgent Property
DistributionCleanupTaskName Property
DistributionDatabase Property
DistributionJobID Property
DistributionServer Property
DistributionWorkingDirectory Property
Distributor Property
DistributorAvailable Property
DistributorInstalled Property
DistributorLocal Property
DropDestObjectsFirst Property
DropLogins Property
DTSPackageLocation Property
DTSPackageName Property
DTSPackagePassword Property
DynamicFilterHostName Property
DynamicFilterLogin Property
DynamicFilters Property
DynamicReconfigure Property
DynamicSnapshotJobId Property
DynamicSnapshotLocation Property
Expand Minimize
This topic has not yet been rated - Rate this topic

DatabaseFiles Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The DatabaseFiles property identifies operating system files that store table or index data as targets of a backup or restore operation.

Copy 

object
.DatabaseFiles [=value]
object

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

value

SQL Distributed Management Objects (SQL-DMO) multistring that identifies one or more operating system files by logical name

String

Read/write

Copy 
HRESULT GetDatabaseFiles(SQLDMO_LPBSTR pRetVal);
HRESULT SetDatabaseFiles(SQLDMO_LPCSTR NewValue);
ms135143.note(en-US,SQL.90).gifNote:
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 using SysFreeString.

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.

For more information about setting multistring parameters, see Using SQL-DMO Multistrings.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.