/// <summary> /// Sets data file and transaction log file properties for this database. /// </summary> /// <param name="props"> /// A list of properties to set. /// </param> /// <remarks> /// Only the data file and transaction log file properties are used. /// You cannot set the owner, create date, etc. properties of the database. /// </remarks> public void SetDatabaseProperties(SqlDatabaseProperties props) { NativeMethods.IDBFile dataFile = dmoDatabase.GetFileGroups().Item(1).GetDBFiles().Item(1); NativeMethods.ILogFile logFile = dmoDatabase.GetTransactionLog().GetLogFiles().Item(1); dataFile.SetFileGrowthType((props.DataFile.FileGrowthType == SqlFileGrowthType.MB) ? NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB : NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent); dataFile.SetFileGrowth(props.DataFile.FileGrowth); dataFile.SetMaximumSize(props.DataFile.MaximumSize); logFile.SetFileGrowthType((props.LogFile.FileGrowthType == SqlFileGrowthType.MB) ? NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB : NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent); logFile.SetFileGrowth(props.LogFile.FileGrowth); logFile.SetMaximumSize(props.LogFile.MaximumSize); }