InstanceDatabaseLogFile.FileName Property
Gets or sets the path and file name of the instance database log file.
Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
Public Property FileName As String
public string FileName { get; set; }
public:
property String^ FileName {
String^ get ();
void set (String^ value);
}
/** @property */
public String get_FileName ()
/** @property */
public void set_FileName (String value)
public function get FileName () : String
public function set FileName (value : String)
Valeur de propriété
A String, up to 260 characters in length, that specifies the full path and file name of the log file.
Notes
For more information, see os_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.
Exemple
The following examples show how to define a log file for an instance database:
InstanceDatabaseLogFile idb_log =
new InstanceDatabaseLogFile(idb, "MyInst_LogFile1");
idb_log.FileName = @"C:\NS\Full\MyInst_LogFile1.ldf";
idb_log.InitialSize = "3MB";
idb_log.MaxSize = "10MB";
idb_log.GrowthIncrement = "10%";
idb.InstanceDatabaseLogFiles.Add(idb_log);
Dim idb_log As InstanceDatabaseLogFile = _
New InstanceDatabaseLogFile(idb, "MyInst_LogFile1")
idb_log.FileName = "C:\NS\Full\MyInst_LogFile1.ldf"
idb_log.InitialSize = "3MB"
idb_log.MaxSize = "10MB"
idb_log.GrowthIncrement = "10%"
idb.InstanceDatabaseLogFiles.Add(idb_log)
Sécurité des threads
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.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
InstanceDatabaseLogFile Class
InstanceDatabaseLogFile Members
Microsoft.SqlServer.Management.Nmo Namespace
Autres ressources
CREATE DATABASE (Transact-SQL)
Définition de la base de données d'instance
FileName Element for LogFile (ICF)