Hello!
I recently discovered that we where missing backing up a database on a client. Asking around no one remembered removing the database in question from the subclient. Luckely this is a sandbox system, that also means we only keep 7 days of backups. Looking over them all of them was missing the database.So I looked in the SQLiDA.log file and had to scroll back all the way until March 1:st. On that day something happened. At the time of the backup, IntelliSnap, it seems the database is missing on the SQL server for whatever reason. As I understand it, the SQLiDA checks the sublient content and then checks the SQL server. If a database is missing on the SQL server the SQLiDA removes that database from the sublient, with as far as I know no notification!?! And the backup was marked as successfull!!
I understand that the database would go into the default subclient, and would be backed up there. But in our case the original sublient is doing Intellisnap backups, due to the size of the database and the default one isn’t. It doesen’t do them as frequent either.
I hope I have this backwards and that I am missing an event or alert or something.
Or isn’t there a notification anywhere that a subclient content was changed?
//Henke
Below is a snippet of the logfile.
92c 03/01 17:00:14 2275814 CSQLBackup::generateCollectFile(706): -Info-: Getting the list of databases from the subclient content for a snap FULL backup job
10336 192c 03/01 17:00:14 2275814 CSQLBackup::isJobInitiatedFromOSC(11851): -Warn--: Job is not initiated from OSC r5].
10336 192c 03/01 17:00:14 2275814 CSQLCommon::getSubclientType(2191): -Debug-: SubclientType i1]
10336 192c 03/01 17:00:14 2275814 CSQLBackup::generateSQLCollectFile() - Time taken to auto-discover databases = 0.007837
10336 192c 03/01 17:00:14 2275814 CSQLBackup::GenerateStreamInfoFile(528): -Debug-: Added stream count r2] to stream info file C:\Program Files\Commvault\ContentStore\iDataAgent\JobResults\CV_JobResults\2\0\2275814\CVSQLStreamInfo_FULL.info].
10336 192c 03/01 17:00:14 2275814 CsqlDMO::InitializeCOM() - <COM> - Already initialized.
10336 192c 03/01 17:00:14 2275814 CSQLBackup::getOnDemandFilePath() - Cant get the value of EX_EX2_EXJ_OnDemandFilePath On Demand reg value under key MSSQLAgent Performing normal backup!
10336 192c 03/01 17:00:14 2275814 CSQLCommon::isSkipSharepointContentDB(2531): -Debug-: Register key :nSkipRBSdb] NOT found, by default, skipping sharepoint content database.
10336 192c 03/01 17:00:14 2275814 CSQLClientDll::lookupSpContentDBbyClientId(6289): -Debug-: Using Client id U666] to get list of databases being protected using SPiDA.
10336 192c 03/01 17:00:14 2275814 CSQLClientDll::lookupSpContentDBbyClientId(6303): -Warn--: Empty database list received from server..
10336 192c 03/01 17:00:14 2275814 CSQLBackup::generateSQLCollectFile() - Database FEX2] found in content.
10336 192c 03/01 17:00:14 2275814 CsqlDMO::isDatabaseExists() - Error: .
10336 192c 03/01 17:00:14 2275814 CSQLBackup::generateSQLCollectFile(1284): -Warn--: Database (EX2) doesn't exist. It might have been deleted.
10336 192c 03/01 17:00:14 2275814 CsqlDMO::InitializeCOM() - <COM> - Already initialized.
10336 192c 03/01 17:00:14 2275814 CsqlDMO::isRecoveryModelSimple() - Error: Object reference not set to an instance of an object..
10336 192c 03/01 17:00:14 2275814 CsqlDMO::isDBInFullRecoveryModel(11223): -Error-: Error: 1Object reference not set to an instance of an object.].
10336 192c 03/01 17:00:14 2275814 CSQLBackup::generateSQLCollectFile(1289): -Debug-: Database (EX2) doesn't exist, deleting it from subclient content.