ApplicationDatabaseOptions Class
Represents the database options for an application database.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public NotInheritable Class ApplicationDatabaseOptions
Inherits NamedSmoObject
public sealed class ApplicationDatabaseOptions : NamedSmoObject
public ref class ApplicationDatabaseOptions sealed : public NamedSmoObject
public final class ApplicationDatabaseOptions extends NamedSmoObject
public final class ApplicationDatabaseOptions extends NamedSmoObject
Remarks
Use the ApplicationDatabaseOptions class to configure the default filegroup and collation for the application database.
Specifying application database properties is optional. For more information about default values, see Defining the Application Database.
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.ApplicationDatabaseOptions
Example
The following examples show how to define application database options:
// Create ApplicationDatabaseOptions object
ApplicationDatabaseOptions adb =
new ApplicationDatabaseOptions(myApplication, "MyAppDB");
// 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 log file
ApplicationDatabaseLogFile adb_log =
new ApplicationDatabaseLogFile(adb, "MyApp_LogFile1");
adb_log.FileName = @"C:\NS\Full\MyApp_LogFile1.ldf";
adb_log.InitialSize = "5MB";
adb_log.MaxSize = "20MB";
adb_log.GrowthIncrement = "10%";
adb.ApplicationDatabaseLogFiles.Add(adb_log);
// Define database options
adb.CollationName = "Latin1_General_CS_AS";
adb.DefaultFileGroup = "PRIMARY";
// Assign options to ApplicationDatabaseOptions property
myApplication.ApplicationDatabaseOptions = adb;
' Create ApplicationDatabaseOptions object
Dim adb As ApplicationDatabaseOptions = _
New ApplicationDatabaseOptions(myApplication, "MyAppDB")
' 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)
' Define and add a log file
Dim adb_log As ApplicationDatabaseLogFile = _
New ApplicationDatabaseLogFile(adb, "MyApp_LogFile1")
adb_log.FileName = "C:\NS\Full\MyApp_LogFile1.ldf"
adb_log.InitialSize = "5MB"
adb_log.MaxSize = "20MB"
adb_log.GrowthIncrement = "10%"
adb.ApplicationDatabaseLogFiles.Add(adb_log)
' Define database options.
adb.CollationName = "Latin1_General_CS_AS"
adb.DefaultFileGroup = "PRIMARY"
' Assign options to the ApplicationDatabaseOptions property.
myApplication.ApplicationDatabaseOptions = adb
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
ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace
Other Resources
Defining the Application Database
CollationName Element (ADF)
DefaultFileGroup Element (ADF)