ApplicationDatabaseFile Class
Defines an application database data file.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public NotInheritable Class ApplicationDatabaseFile
Inherits NamedSmoObject
public sealed class ApplicationDatabaseFile : NamedSmoObject
public ref class ApplicationDatabaseFile sealed : public NamedSmoObject
public final class ApplicationDatabaseFile extends NamedSmoObject
public final class ApplicationDatabaseFile extends NamedSmoObject
Remarks
A ApplicationDatabaseFile object contains information about one application database data file in a ApplicationDatabaseFileGroup object. Each filegroup can contain one or more data files.
If you want to alter the application database after creating the application, use the SQL Server tools, such as SQL Server Management Studio.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Nmo.ApplicationDatabaseFile
Example
The following examples show how to define an application database file:
// Define and add a filegroup
ApplicationDatabaseFileGroup adb_fg =
new ApplicationDatabaseFileGroup(adb, "PRIMARY");
adb.ApplicationDatabaseFileGroups.Add(adb_fg);
// Define and add a database file
ApplicationDatabaseFile adb_file1 =
new ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1");
adb_file1.FileName = @"C:\NS\Full\MyApp_PrimaryFile1.mdf";
adb_file1.InitialSize = "10MB";
adb_file1.MaxSize = "50MB";
adb_file1.GrowthIncrement = "10%";
adb_fg.ApplicationDatabaseFiles.Add(adb_file1);
' Define and add a filegroup
Dim adb_fg As ApplicationDatabaseFileGroup = _
New ApplicationDatabaseFileGroup(adb, "PRIMARY")
adb.ApplicationDatabaseFileGroups.Add(adb_fg)
' Define and add a database file
Dim adb_file1 As ApplicationDatabaseFile = _
New ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1")
adb_file1.FileName = "C:\NS\Full\MyApp_PrimaryFile1.mdf"
adb_file1.InitialSize = "10MB"
adb_file1.MaxSize = "50MB"
adb_file1.GrowthIncrement = "10%"
adb_fg.ApplicationDatabaseFiles.Add(adb_file1)
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
ApplicationDatabaseFile Members
Microsoft.SqlServer.Management.Nmo Namespace