Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Initializes a new instance of the ApplicationDatabaseFile class with the parent ApplicationDatabaseFileGroup and a name.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public Sub New ( _
applicationDatabaseFileGroup As ApplicationDatabaseFileGroup, _
name As String _
)
public ApplicationDatabaseFile (
ApplicationDatabaseFileGroup applicationDatabaseFileGroup,
string name
)
public:
ApplicationDatabaseFile (
ApplicationDatabaseFileGroup^ applicationDatabaseFileGroup,
String^ name
)
public ApplicationDatabaseFile (
ApplicationDatabaseFileGroup applicationDatabaseFileGroup,
String name
)
public function ApplicationDatabaseFile (
applicationDatabaseFileGroup : ApplicationDatabaseFileGroup,
name : String
)
Parameter
- applicationDatabaseFileGroup
The parent ApplicationDatabaseFileGroup object for the database file.
name
A String, between 1 and 128 characters in length, specifying the logical name of the data file.You cannot change the name. To alter an application database after creating the application, use the SQL Server tools, such as SQL Server Management Studio.
Hinweise
In addition to providing values for the parameters, you also must set the FileName property.
The name parameter specifies the logical name of the database data file. The logical name is used to refer to the file when managing the data file.
Using Notification Services Management Objects (NMO), you cannot update any database properties after creating the application.
Beispiel
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)
Plattformen
Entwicklungsplattformen
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Zielplattforme
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Siehe auch
Verweis
ApplicationDatabaseFile Class
ApplicationDatabaseFile Members
Microsoft.SqlServer.Management.Nmo Namespace
Andere Ressourcen
ALTER DATABASE (Transact-SQL)
Definieren der Anwendungsdatenbank
LogicalName Element for FileSpec (ADF)