private static void UpdateDatabaseWithSnapShot(Data.ApplicationDataSet.DatabaseInfoRow dataRow, string snapShotError) { try { dataRow.SnapShotDate = DateTime.Now; dataRow.SnapShotError = snapShotError; Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo); } catch (Exception ex) { string errorMessage = string.Format("DatabaseInfoRow.ID:{0} - ex:{1} ex.Inner:{2}", dataRow.ID, ex, ex.InnerException); VNC.AppLog.Error(errorMessage, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0); } }
public static void UpdateDataSet(this MSMO.Database database, Data.ApplicationDataSet.DatabaseInfoRow dataRow) { try { dataRow.IndexSpaceUsage = database.IndexSpaceUsage; dataRow.DataSpaceUsage = database.DataSpaceUsage; dataRow.Size = database.Size; dataRow.SpaceAvailable = database.SpaceAvailable; } catch (Exception ex) { VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); // TODO(crhodes): // Wrap anything above that throws an exception that we want to ignore, // e.g. property not available because of SQL Edition. } }
public static void UpdateDataSet(this MSMO.Database database, Data.ApplicationDataSet.DatabaseInfoRow databaseRow) { try { databaseRow.IndexSpaceUsage = database.IndexSpaceUsage; databaseRow.DataSpaceUsage = database.DataSpaceUsage; databaseRow.Size = database.Size; databaseRow.SpaceAvailable = database.SpaceAvailable; } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }
public static void TakeDatabaseSnapShot(SQLInformation.Data.ApplicationDataSet.DatabasesRow databaseRow) { #if TRACE long startTicks = VNC.AppLog.Trace4("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0); #endif Data.ApplicationDataSet.DatabaseInfoRow databaseInfoRow = null; try { databaseInfoRow = Common.ApplicationDataSet.DatabaseInfo.NewDatabaseInfoRow(); databaseInfoRow.SnapShotDate = databaseRow.SnapShotDate; databaseInfoRow.SnapShotError = databaseRow.SnapShotError; databaseInfoRow.Database_ID = databaseRow.ID; databaseInfoRow.Name_Database = databaseRow.Name_Database; databaseInfoRow.Instance_ID = databaseRow.Instance_ID; databaseInfoRow.Name_Instance = databaseRow.Name_Instance; databaseInfoRow.IndexSpaceUsage = databaseRow.IndexSpaceUsage; databaseInfoRow.DataSpaceUsage = databaseRow.DataSpaceUsage; databaseInfoRow.Size = databaseRow.Size; databaseInfoRow.SpaceAvailable = databaseRow.SpaceAvailable; Common.ApplicationDataSet.DatabaseInfo.AddDatabaseInfoRow(databaseInfoRow); Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo); } catch (Exception ex) { VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); databaseInfoRow.SnapShotDate = DateTime.Now; databaseInfoRow.SnapShotError = ex.ToString().Substring(0, 256); Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo); } #if TRACE VNC.AppLog.Trace4("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks); #endif }