ApplicationDatabaseOptions Constructor
Initializes a new instance of the ApplicationDatabaseOptions class.
Spazio dei nomi: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintassi
'Dichiarazione
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
)
Parametri
- 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.
Esempio
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
Piattaforme
Piattaforme di sviluppo
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Piattaforme di destinazione
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Vedere anche
Riferimento
ApplicationDatabaseOptions Class
ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace
Altre risorse
Definizione del database dell'applicazione
CollationName Element (ADF)
DefaultFileGroup Element (ADF)