Share via

ApplicationDatabaseOptions Constructor

  • Article

Initializes a new instance of the ApplicationDatabaseOptions class.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub New ( _
    application As Application, _
    name As String _
)

public ApplicationDatabaseOptions (
    Application application,
    string name
)

public:
ApplicationDatabaseOptions (
    Application^ application, 
    String^ name
)

public ApplicationDatabaseOptions (
    Application application, 
    String name
)

public function ApplicationDatabaseOptions (
    application : Application, 
    name : String
)

Parameters

  • application
    The Application for the database options.
  • name
    A String containing a name for the database options. This name is not used by Notification Services.

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

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 Class
ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining the Application Database
CollationName Element (ADF)
DefaultFileGroup Element (ADF)