Skip to main content
Sign in Menu

Venio Console: How to restore the deleted row of Venio PCD

Pragya Pokhrel
  • Updated

Problem

How to restore the row that got deleted in Venio PCD.

Resolution

Sometimes when projects get deleted accidently, in addition to restoring the project database, we need to restore the row of table named 'tbl_pj_projectsetup' that exists in VenioPCD. This gets deleted when the project database is deleted. So you need to have a backup of the  VenioPCD so that you can grab this row and insert it onto your current VenioPCD.  In order to insert this row you need do run the following statement

Please note that we are using  2 databases in this example

  • [VenioPCD]
  • [VenioPCD_backedup]

Please make sure you replace this with the proper PCD name. [VenioPCD] being the current PCD and [VenioPCD_backedup] being the name of restored VenioPCD database. We are also assuming that these databases are in the same server.

set identity_insert [VenioPCD].[dbo].tbl_pj_ProjectSetup ON
insert into [VenioPCD].[dbo].tbl_pj_ProjectSetup
( 
[ProjectID]
,[ClientName]
,[clientid]
,[ProjectName]
,[DatabaseInstanceName]
,[DedupingFlag]
,[HashAlgorithm]
,[DeNistingFlag]
,[IndexingFlag]
,[RemoveSysFileFlag]
,[FullTextSearchLevel]
,[FileServerLocation]
,[IndexLocation]
,[CreatedDate]
,[UpdatedDate]
,[CreatedBy]
,[UpdatedBy]
,[IndexFullText]
,[IndexMeta]
,[SSID]
,[ISID]
,[DSID]
,[MatterNumber]
,[AttorneyName]
,[Notes]
,[LanguageIdentification]
,[OCRTextMinimumThreshold]
,[DefaultFullTextContent]
,[AllowEmailAnalysis]
,[CreatedMachineName]
,[FSID]
,[IngestTimeoutPerFile]
,[EmailAlertEnabled]
,[BackupStatus]
,[AllowOCR]
,[AutoQueueOCR]
,[HighlightPrivilegedTermForDesktop]
,[HighlightPrivilegedTermForWeb]
,[EdocEmbeddedFilter]
,[EmailEmbeddedFilter]
,[PPTEmbeddedFilter]
,[HighlightSearchTermForDesktop]
,[HighlightSearchTermForWeb]
,[RestrictMediaUpload]
,[RestrictExport]
,[AllowLocalStorageToMediaUpload]
,[AllowLocalStorageToExport]
,[WorkingMachineName]
,[AllowTiff]
,[AllowColorTiff]
,[EmailFreqWeight]
,[EmailNonGarbageWeight]
,[EmailSimilarityWeight]
,[NonGarbageChars]
,[MaxPageLimit]
,[TimeoutMultiplier]
,[GroupDatePriority]
,[maxOcrTryCount]
,[PCTagPropagationsetting]
,[DuplicateTagPropagationSetting]
,[ReviewDatabaseInstanceName]
,[ReviewDSID]
,[DefaultReviewerHourlyRate]
,[PropagateTagToEmailThread]
,[FileExtensionFilterLevel]
,[ApplyFileExtensionFilterOnContainer]
,[FileTypeFilterLevel]
,[ApplyFileTypeFilterOnContainer]
,[NativeTiffExtOption]
,[OCRTextThresholdValue]
,[LocalTimeZone]
,[NsfDateTimeFormat]
,[ShowEmailHeaderInFulltext]
,[TzTimeZone]
,[ReviewerRateType]
,[BlankThreshold]
,[LittleContentThreshold]
,[AutoQueueNative]
,[TiffPrintDocLimit]
,[TiffPrintPageLimit]
,[AutoQueueNDDSig]
,[SlipSheetSettings]
,[NDDSettings]
,[EnableNativeAutoPrefetch]
,[UseDedicatedServerOnly]
,[MinCharForLangId]
,[MaxCharToReadForLangId]
,[AutoTiffOCRForNoTextFiles]
,[AdvancedTiffOption]
,[ProjectCreatedVersion]
,[ProjectUpdatedVersion]
,[MinValidDateTime]
,[MinFreeSpaceRequiredForTempLocationInGB]
,[MinFreeSpaceRequiredForProjectLocationInGB]
,[IgnoreStateError]
,[EmailNotificationTimeoutInMinute]
,[AutoCopyCrashedDocument]
,[IsImageTypePDF]
,[ContentAccessVersion]
,[CleanContentVersion]
,[ShowIngestionErrorsWarningInExport]
,[IncludePartialOCRedFile]
,[ExtractTextFromMasterViewInPowerpoint]
,[TrackChangesOptionForFulltext]
,[ProjectCreatedFromVoD]
,[AllowAutoLaunchEmailThreading]
,[DoNotComputeLanguageIdentificationForSpreadsheets]
,[HashAlgorithmSecondary]
,[RemoveRedactedTiffOCRTextIFSlipSheet]
,[FileCopyOption]
,[LangIDFactoryType]
,[ExtractInternetEmailHeader]
,[IndexEmailHeader]
,[PopulateCustodianDedup]
,[AutoSearchTagSettings]
,[DefaultTiffTimeout]
,[CreateDefaultRedactionSets]
,[ExtractNSFView]
,[ComputeDedupeBasedOnCustodianPriority]
,[AutoComputeInclusiveEmail]
,[DefaultTiffColorOption]
,[NDDTagPropagationSetting]
,[SearchDuplicateOption]
,[ExcludeDisclaimerDuringIndexing]
,[HashFieldSettings]
,[IFSID]
,[AutoQueueTranscribing]
,[AutoPopulateDuplicateFilePath]
,[MaxDSJobRetryCount]
)

select [ProjectID]
,[ClientName]
,[clientid]
,[ProjectName]
,[DatabaseInstanceName]
,[DedupingFlag]
,[HashAlgorithm]
,[DeNistingFlag]
,[IndexingFlag]
,[RemoveSysFileFlag]
,[FullTextSearchLevel]
,[FileServerLocation]
,[IndexLocation]
,[CreatedDate]
,[UpdatedDate]
,[CreatedBy]
,[UpdatedBy]
,[IndexFullText]
,[IndexMeta]
,[SSID]
,[ISID]
,[DSID]
,[MatterNumber]
,[AttorneyName]
,[Notes]
,[LanguageIdentification]
,[OCRTextMinimumThreshold]
,[DefaultFullTextContent]
,[AllowEmailAnalysis]
,[CreatedMachineName]
,[FSID]
,[IngestTimeoutPerFile]
,[EmailAlertEnabled]
,[BackupStatus]
,[AllowOCR]
,[AutoQueueOCR]
,[HighlightPrivilegedTermForDesktop]
,[HighlightPrivilegedTermForWeb]
,[EdocEmbeddedFilter]
,[EmailEmbeddedFilter]
,[PPTEmbeddedFilter]
,[HighlightSearchTermForDesktop]
,[HighlightSearchTermForWeb]
,[RestrictMediaUpload]
,[RestrictExport]
,[AllowLocalStorageToMediaUpload]
,[AllowLocalStorageToExport]
,[WorkingMachineName]
,[AllowTiff]
,[AllowColorTiff]
,[EmailFreqWeight]
,[EmailNonGarbageWeight]
,[EmailSimilarityWeight]
,[NonGarbageChars]
,[MaxPageLimit]
,[TimeoutMultiplier]
,[GroupDatePriority]
,[maxOcrTryCount]
,[PCTagPropagationsetting]
,[DuplicateTagPropagationSetting]
,[ReviewDatabaseInstanceName]
,[ReviewDSID]
,[DefaultReviewerHourlyRate]
,[PropagateTagToEmailThread]
,[FileExtensionFilterLevel]
,[ApplyFileExtensionFilterOnContainer]
,[FileTypeFilterLevel]
,[ApplyFileTypeFilterOnContainer]
,[NativeTiffExtOption]
,[OCRTextThresholdValue]
,[LocalTimeZone]
,[NsfDateTimeFormat]
,[ShowEmailHeaderInFulltext]
,[TzTimeZone]
,[ReviewerRateType]
,[BlankThreshold]
,[LittleContentThreshold]
,[AutoQueueNative]
,[TiffPrintDocLimit]
,[TiffPrintPageLimit]
,[AutoQueueNDDSig]
,[SlipSheetSettings]
,[NDDSettings]
,[EnableNativeAutoPrefetch]
,[UseDedicatedServerOnly]
,[MinCharForLangId]
,[MaxCharToReadForLangId]
,[AutoTiffOCRForNoTextFiles]
,[AdvancedTiffOption]
,[ProjectCreatedVersion]
,[ProjectUpdatedVersion]
,[MinValidDateTime]
,[MinFreeSpaceRequiredForTempLocationInGB]
,[MinFreeSpaceRequiredForProjectLocationInGB]
,[IgnoreStateError]
,[EmailNotificationTimeoutInMinute]
,[AutoCopyCrashedDocument]
,[IsImageTypePDF]
,[ContentAccessVersion]
,[CleanContentVersion]
,[ShowIngestionErrorsWarningInExport]
,[IncludePartialOCRedFile]
,[ExtractTextFromMasterViewInPowerpoint]
,[TrackChangesOptionForFulltext]
,[ProjectCreatedFromVoD]
,[AllowAutoLaunchEmailThreading]
,[DoNotComputeLanguageIdentificationForSpreadsheets]
,[HashAlgorithmSecondary]
,[RemoveRedactedTiffOCRTextIFSlipSheet]
,[FileCopyOption]
,[LangIDFactoryType]
,[ExtractInternetEmailHeader]
,[IndexEmailHeader]
,[PopulateCustodianDedup]
,[AutoSearchTagSettings]
,[DefaultTiffTimeout]
,[CreateDefaultRedactionSets]
,[ExtractNSFView]
,[ComputeDedupeBasedOnCustodianPriority]
,[AutoComputeInclusiveEmail]
,[DefaultTiffColorOption]
,[NDDTagPropagationSetting]
,[SearchDuplicateOption]
,[ExcludeDisclaimerDuringIndexing]
,[HashFieldSettings]
,[IFSID]
,[AutoQueueTranscribing]
,[AutoPopulateDuplicateFilePath]
,[MaxDSJobRetryCount]
from [VenioPCD_backedup].[dbo].tbl_pj_projectsetup
 where [VenioPCD_backedup].dbo.tbl_pj_projectsetup.DatabaseInstanceName
 =' <replace with your databasename>'

set identity_insert [VenioPCD].[dbo].tbl_pj_ProjectSetup OFF

Related articles

Comments

0 comments

Please sign in to leave a comment.