--Job start date: Feb 15 2012 10:53AM USE EVExchangeArchiveStore1 Feb 15 2012 10:53:40:010AM DBCC results for 'EVExchangeArchiveStore1'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3. Service Broker Msg 9668, State 1: Service Queues analyzed: 3. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. DBCC results for 'sys.sysrowsetcolumns'. There are 918 rows in 11 pages for object "sys.sysrowsetcolumns". DBCC results for 'sys.sysrowsets'. There are 156 rows in 1 pages for object "sys.sysrowsets". DBCC results for 'sysallocunits'. There are 172 rows in 2 pages for object "sysallocunits". DBCC results for 'sys.sysfiles1'. There are 2 rows in 1 pages for object "sys.sysfiles1". DBCC results for 'sys.syshobtcolumns'. There are 918 rows in 11 pages for object "sys.syshobtcolumns". DBCC results for 'sys.syshobts'. There are 156 rows in 1 pages for object "sys.syshobts". DBCC results for 'sys.sysftinds'. There are 0 rows in 0 pages for object "sys.sysftinds". DBCC results for 'sys.sysserefs'. There are 172 rows in 1 pages for object "sys.sysserefs". DBCC results for 'sys.sysowners'. There are 17 rows in 1 pages for object "sys.sysowners". DBCC results for 'sys.sysprivs'. There are 147 rows in 1 pages for object "sys.sysprivs". DBCC results for 'sys.sysschobjs'. There are 162 rows in 8 pages for object "sys.sysschobjs". DBCC results for 'sys.syscolpars'. There are 646 rows in 26 pages for object "sys.syscolpars". DBCC results for 'sys.sysnsobjs'. There are 1 rows in 1 pages for object "sys.sysnsobjs". DBCC results for 'sys.syscerts'. There are 0 rows in 0 pages for object "sys.syscerts". DBCC results for 'sys.sysxprops'. There are 0 rows in 0 pages for object "sys.sysxprops". DBCC results for 'sys.sysscalartypes'. There are 52 rows in 1 pages for object "sys.sysscalartypes". DBCC results for 'sys.systypedsubobjs'. There are 0 rows in 0 pages for object "sys.systypedsubobjs". DBCC results for 'sys.sysidxstats'. There are 307 rows in 5 pages for object "sys.sysidxstats". DBCC results for 'sys.sysiscols'. There are 475 rows in 3 pages for object "sys.sysiscols". DBCC results for 'sys.sysbinobjs'. There are 23 rows in 1 pages for object "sys.sysbinobjs". DBCC results for 'sys.sysobjvalues'. There are 334 rows in 141 pages for object "sys.sysobjvalues". DBCC results for 'sys.sysclsobjs'. There are 15 rows in 1 pages for object "sys.sysclsobjs". DBCC results for 'sys.sysrowsetrefs'. There are 0 rows in 0 pages for object "sys.sysrowsetrefs". DBCC results for 'sys.sysremsvcbinds'. There are 0 rows in 0 pages for object "sys.sysremsvcbinds". DBCC results for 'sys.sysxmitqueue'. There are 0 rows in 0 pages for object "sys.sysxmitqueue". DBCC results for 'sys.sysrts'. There are 1 rows in 1 pages for object "sys.sysrts". DBCC results for 'sys.sysconvgroup'. There are 0 rows in 0 pages for object "sys.sysconvgroup". DBCC results for 'sys.sysdesend'. There are 0 rows in 0 pages for object "sys.sysdesend". DBCC results for 'sys.sysdercv'. There are 0 rows in 0 pages for object "sys.sysdercv". DBCC results for 'sys.syssingleobjrefs'. There are 195 rows in 1 pages for object "sys.syssingleobjrefs". DBCC results for 'sys.sysmultiobjrefs'. There are 103 rows in 2 pages for object "sys.sysmultiobjrefs". DBCC results for 'sys.sysdbfiles'. There are 2 rows in 1 pages for object "sys.sysdbfiles". DBCC results for 'sys.sysguidrefs'. There are 0 rows in 0 pages for object "sys.sysguidrefs". DBCC results for 'sys.sysqnames'. There are 91 rows in 1 pages for object "sys.sysqnames". DBCC results for 'sys.sysxmlcomponent'. There are 93 rows in 1 pages for object "sys.sysxmlcomponent". DBCC results for 'sys.sysxmlfacet'. There are 97 rows in 1 pages for object "sys.sysxmlfacet". DBCC results for 'sys.sysxmlplacement'. There are 17 rows in 1 pages for object "sys.sysxmlplacement". DBCC results for 'sys.sysobjkeycrypts'. There are 0 rows in 0 pages for object "sys.sysobjkeycrypts". DBCC results for 'sys.sysasymkeys'. There are 0 rows in 0 pages for object "sys.sysasymkeys". DBCC results for 'sys.syssqlguides'. There are 0 rows in 0 pages for object "sys.syssqlguides". DBCC results for 'sys.sysbinsubobjs'. There are 0 rows in 0 pages for object "sys.sysbinsubobjs". DBCC results for 'HoldGroup'. There are 0 rows in 0 pages for object "HoldGroup". DBCC results for 'HoldSaveset'. There are 0 rows in 0 pages for object "HoldSaveset". DBCC results for 'JournalArchive'. There are 14537 rows in 725 pages for object "JournalArchive". DBCC results for 'JournalDelete'. There are 639061 rows in 78621 pages for object "JournalDelete". DBCC results for 'WatchSISPartFile'. There are 0 rows in 1 pages for object "WatchSISPartFile". DBCC results for 'JournalRestore'. There are 1 rows in 1 pages for object "JournalRestore". DBCC results for 'JournalUpdate'. There are 143151 rows in 6412 pages for object "JournalUpdate". DBCC results for 'Saveset'. There are 10772893 rows in 183558 pages for object "Saveset". DBCC results for 'SavesetProperty'. There are 10772897 rows in 84005 pages for object "SavesetProperty". DBCC results for 'SavesetStore'. There are 0 rows in 0 pages for object "SavesetStore". DBCC results for 'Vault'. There are 118557 rows in 2754 pages for object "Vault". DBCC results for 'WatchFile'. There are 0 rows in 1 pages for object "WatchFile". DBCC results for 'JournalStub'. There are 0 rows in 1 pages for object "JournalStub". DBCC results for 'UnrelatedArchiveVault'. There are 0 rows in 0 pages for object "UnrelatedArchiveVault". DBCC results for 'HashAlgorithmInfo'. There are 0 rows in 0 pages for object "HashAlgorithmInfo". DBCC results for 'VersionInfo'. There are 1 rows in 1 pages for object "VersionInfo". DBCC results for 'PartitionCache'. There are 3 rows in 1 pages for object "PartitionCache". DBCC results for 'ArchiveSummary'. There are 269 rows in 2 pages for object "ArchiveSummary". DBCC results for 'ArchiveSummary_Cache'. There are 0 rows in 1 pages for object "ArchiveSummary_Cache". DBCC results for 'ArchiveUsageSummary'. There are 2662 rows in 19 pages for object "ArchiveUsageSummary". DBCC results for 'ArchiveUsageTimeBasedSummary'. There are 2972 rows in 145 pages for object "ArchiveUsageTimeBasedSummary". DBCC results for 'ArchiveUsageSummaryByFileType'. There are 0 rows in 0 pages for object "ArchiveUsageSummaryByFileType". DBCC results for 'ArchiveSummaryRetention'. There are 4 rows in 1 pages for object "ArchiveSummaryRetention". DBCC results for 'ConfigSettings'. There are 5 rows in 1 pages for object "ConfigSettings". DBCC results for 'sys.queue_messages_1977058079'. There are 0 rows in 0 pages for object "sys.queue_messages_1977058079". DBCC results for 'sys.queue_messages_2009058193'. There are 0 rows in 0 pages for object "sys.queue_messages_2009058193". DBCC results for 'sys.queue_messages_2041058307'. There are 0 rows in 0 pages for object "sys.queue_messages_2041058307". DBCC results for 'ArchivePoint'. There are 3010 rows in 60 pages for object "ArchivePoint". DBCC results for 'Collection'. There are 302982 rows in 5561 pages for object "Collection". DBCC results for 'FSAVaultProperties'. There are 0 rows in 0 pages for object "FSAVaultProperties". DBCC results for 'SISPart'. There are 1317286 rows in 13518 pages for object "SISPart". DBCC results for 'HoldConsumer'. There are 0 rows in 0 pages for object "HoldConsumer". DBCC results for 'HoldData'. There are 0 rows in 0 pages for object "HoldData". DBCC results for 'Saveset_SISPart'. There are 2222950 rows in 12098 pages for object "Saveset_SISPart". CHECKDB found 0 allocation errors and 0 consistency errors in database 'EVExchangeArchiveStore1'. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Feb 15 2012 11:13:57:593AM -- **** CHECKDB FINISHED **** -- **** **** -- **** **** -- **** **** -- Database original recovery model - FULL -- Waiting to change recovery model to SIMPLE... Recovery model now SIMPLE, please do not forget to restore recovery model if necessary. USE tempdb -- create tempdb tables -- LOCK DATABASE -- *** USE EVExchangeArchiveStore1 --Collect info section start time: Feb 15 2012 11:13AM -- GET UDF INFO (both schema-bound and uses_database_collation) -- GET VIEW INFO (both schema-bound and uses_database_collation) -- GET PK INFO -- GET FOREIGN KEY CONSTRAINTS INFO -- GET FOREIGN KEY CONSTRAINTS & COLUMNS INFO -- GET DEFAULT CONSTRAINTS INFO -- GET CHECK CONSTRAINTS INFO -- GET COMPUTED COLUMNS INFO -- GET TRIGGER INFO -- GET TRIGGER ORDER INFO -- GET INDEXES INFO -- GET PERMISSIONS INFO -- GET USER STATISTICS INFO -- GET USER STATISTICS INFO WITH COLUMNS -- --Collect info section finish time: Feb 15 2012 11:13AM -- -- --DROP info section start time: Feb 15 2012 11:13AM -- -- *** -- DROP UDF -- DROP UDF passed. -- *** -- DROP VIEWS -- DROP VIEW passed. -- *** -- DROP TRIGGERS -- DROP TRIGGERS PASSED. -- *** -- DROP HAND-MADE STATISTICS -- DROP HAND-MADE STATISTICS passed -- *** -- DROP FK ALTER TABLE [dbo].[HoldSaveset] DROP CONSTRAINT [FK_HoldGroupIdentity_HoldSaveset] ALTER TABLE [dbo].[WatchFile] DROP CONSTRAINT [FK_TransactionId_WatchFile] ALTER TABLE [dbo].[Saveset_SISPart] DROP CONSTRAINT [FK_Saveset_SISPart_Saveset] ALTER TABLE [dbo].[HoldSaveset] DROP CONSTRAINT [FK_SavesetIdentity_HoldSaveset] ALTER TABLE [dbo].[SavesetProperty] DROP CONSTRAINT [FK_SavesetIdentity_SavesetProperty] ALTER TABLE [dbo].[SavesetStore] DROP CONSTRAINT [FK_SavesetIdentity_SavesetStore] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [FK_JournalArchive_Saveset] ALTER TABLE [dbo].[JournalRestore] DROP CONSTRAINT [FK_JournalRestore_VaultID] ALTER TABLE [dbo].[JournalUpdate] DROP CONSTRAINT [FK_ArchiveFolderIdentity_JournalUpdate] ALTER TABLE [dbo].[FSAVaultProperties] DROP CONSTRAINT [CONS_FK_Vault_FSAVaultProperties] ALTER TABLE [dbo].[JournalDelete] DROP CONSTRAINT [FK_VaultIdentity_JournalDelete] ALTER TABLE [dbo].[Saveset] DROP CONSTRAINT [FK_VaultIdentity_Saveset] ALTER TABLE [dbo].[FSAVaultProperties] DROP CONSTRAINT [FK_HashAlgorithmInfo_FSAVaultProperties] ALTER TABLE [dbo].[JournalStub] DROP CONSTRAINT [FK_ArchivePointIdentity_JournalStub] ALTER TABLE [dbo].[Vault] DROP CONSTRAINT [FK_ArchivePointIdentity_Vault] ALTER TABLE [dbo].[HoldSaveset] DROP CONSTRAINT [FK_ArchivePointIdentity_HoldSaveset] ALTER TABLE [dbo].[Saveset] DROP CONSTRAINT [FK_CollectionIdentity_Collection] ALTER TABLE [dbo].[Saveset_SISPart] DROP CONSTRAINT [FK_Saveset_SISPart_SISPart] ALTER TABLE [dbo].[HoldGroup] DROP CONSTRAINT [FK_HoldConsumerIdentity_HoldGroup] ALTER TABLE [dbo].[HoldSaveset] DROP CONSTRAINT [FK_HoldData_HoldSaveset] -- DROP FK passed -- *** -- DROP DEFAULT CONSTRAINTS ALTER TABLE [dbo].[ArchivePoint] DROP CONSTRAINT [DF_ArchivePoint_IndexUpdatesPending] ALTER TABLE [dbo].[JournalUpdate] DROP CONSTRAINT [DF_JournalUpdate_IndexCommitted] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [DF__JournalAr__Recor__0A688BB1] ALTER TABLE [dbo].[WatchFile] DROP CONSTRAINT [DF_ItemSecured_WatchFile] ALTER TABLE [dbo].[JournalStub] DROP CONSTRAINT [DF_JournalStub_RecordCreationDate] ALTER TABLE [dbo].[SISPart] DROP CONSTRAINT [DF__SISPart__LargeFi__11158940] ALTER TABLE [dbo].[SISPart] DROP CONSTRAINT [DF_FPVersion_SISPart] ALTER TABLE [dbo].[WatchSISPartFile] DROP CONSTRAINT [DF_FPVersion_WatchSISPartFile] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [DF_DeleteFailedWFItem_JournalArchive] ALTER TABLE [dbo].[WatchSISPartFile] DROP CONSTRAINT [DF_LargeFile_WatchSISPartFile] ALTER TABLE [dbo].[JournalDelete] DROP CONSTRAINT [DF__JournalDe__Delet__151B244E] ALTER TABLE [dbo].[ArchivePoint] DROP CONSTRAINT [DF_HighestPurgedJournalSeqNo_ArchivePoint] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [DF_RemoveSafetyCopy_JournalArchive] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [DF_OnPrimaryDevice_JournalArchive] ALTER TABLE [dbo].[WatchFile] DROP CONSTRAINT [DF_LargeFile_WatchFile] ALTER TABLE [dbo].[JournalDelete] DROP CONSTRAINT [DF_JournalDelete_IndexCommitted] ALTER TABLE [dbo].[WatchFile] DROP CONSTRAINT [DF__WatchFile__ItemI__347EC10E] ALTER TABLE [dbo].[JournalDelete] DROP CONSTRAINT [DF_JournalDelete_DeletionDate] ALTER TABLE [dbo].[WatchSISPartFile] DROP CONSTRAINT [DF__WatchSISP__ItemI__3572E547] ALTER TABLE [dbo].[Vault] DROP CONSTRAINT [DF_Vault_DeletionRunDate] ALTER TABLE [dbo].[ArchiveSummary] DROP CONSTRAINT [DF_ArchiveSummary_RefCount] ALTER TABLE [dbo].[ArchiveSummary] DROP CONSTRAINT [DF_ArchiveSummary_IsFSA] ALTER TABLE [dbo].[ArchiveSummary] DROP CONSTRAINT [DF_ArchiveSummary_IncludeInTimeSummaries] ALTER TABLE [dbo].[ArchiveSummary] DROP CONSTRAINT [DF_ArchiveSummary_MissingOriginalSizeRefCount] ALTER TABLE [dbo].[ArchiveUsageTimeBasedSummary] DROP CONSTRAINT [DF_ArchiveUsageTimeBasedSummary_ConsolidationLevel] ALTER TABLE [dbo].[ConfigSettings] DROP CONSTRAINT [DF_ConfigSettings_LastModifiedDate] -- DROP DEFAULT CONSTRAINTS passed -- *** -- DROP CHECK CONSTRAINTS -- DROP CHECK CONSTRAINTS failed -- *** -- DROP INDEXES DROP INDEX [IX_HoldGroup_HoldUserGroupID_HoldConsumerIdentity] ON [dbo].[HoldGroup] DROP INDEX [IX_HoldGroup_HoldConsumerIdentity] ON [dbo].[HoldGroup] DROP INDEX [IX_HoldSaveset_HoldDataIdentity] ON [dbo].[HoldSaveset] DROP INDEX [IX_HoldSaveset_ArchivePointIdentity] ON [dbo].[HoldSaveset] DROP INDEX [IX_HoldSaveset_SSID_HGID_HID] ON [dbo].[HoldSaveset] DROP INDEX [IX_HoldSaveset_HGID_HDID] ON [dbo].[HoldSaveset] DROP INDEX [IX_JournalArchive_SavesetIdentity] ON [dbo].[JournalArchive] DROP INDEX [IX_JA_ArchivePointIdentity_IndexSeqNo_BackupComplete_IndexCommited] ON [dbo].[JournalArchive] DROP INDEX [IX_JA_VaultIdentity] ON [dbo].[JournalArchive] DROP INDEX [IX_JournalArchive_ArchivePointIdentity_IndexCommited] ON [dbo].[JournalArchive] DROP INDEX [IX_JournalArchive_IdPartition] ON [dbo].[JournalArchive] DROP INDEX [IX_VaultIdentity] ON [dbo].[JournalDelete] DROP INDEX [IX_JournalDelete_IC_DD] ON [dbo].[JournalDelete] DROP INDEX [IX_JournalDelete_DR_VI_VID] ON [dbo].[JournalDelete] DROP INDEX [IX_JD_DeletionStatus] ON [dbo].[JournalDelete] DROP INDEX [IX_JD_ArchivePointIdentity_ItemSeqNo2] ON [dbo].[JournalDelete] ALTER TABLE [dbo].[JournalUpdate] DROP CONSTRAINT [IX_JournalUpdate_APIdent_USN] DROP INDEX [IX_JournalUpdate_NewArchiveFolderIdentity] ON [dbo].[JournalUpdate] ALTER TABLE [dbo].[Saveset] DROP CONSTRAINT [UN_SavesetIdentity] DROP INDEX [IX_IdTransaction] ON [dbo].[Saveset] DROP INDEX [IX_IdDateTime] ON [dbo].[Saveset] DROP INDEX [IX_Saveset_CollectionIdentity] ON [dbo].[Saveset] DROP INDEX [IX_Saveset_VaultIdentity] ON [dbo].[Saveset] DROP INDEX [IX_Collection_Saveset_Partition] ON [dbo].[Saveset] DROP INDEX [IX_ItemId_Qualifier] ON [dbo].[SavesetProperty] ALTER TABLE [dbo].[Vault] DROP CONSTRAINT [UN_VaultIdentity] DROP INDEX [IX_Vault_ArchivePointIdentity] ON [dbo].[Vault] DROP INDEX [IX_SequenceNo1] ON [dbo].[WatchFile] DROP INDEX [IX_IdPartition_ItemName_SequenceNumber] ON [dbo].[WatchFile] DROP INDEX [IX_ItemName_ArchiveTransactionId] ON [dbo].[WatchFile] DROP INDEX [IX_JournalStub_Sensitivity] ON [dbo].[JournalStub] DROP INDEX [IX_JournalStub_VaultId_ItemSeqNo] ON [dbo].[JournalStub] DROP INDEX [IX_JournalStub_RecordCreationDate] ON [dbo].[JournalStub] DROP INDEX [IX_ArchiveSummaryCache_ArchivePointIdentity_FileTypeID] ON [dbo].[ArchiveSummary_Cache] DROP INDEX [IX_ArchiveSummaryCache_ArchivePointIdentity_ArchivedDate] ON [dbo].[ArchiveSummary_Cache] DROP INDEX [IX_ArchiveUsageTimeBasedSummary_ArchivedDate] ON [dbo].[ArchiveUsageTimeBasedSummary] DROP INDEX [IX_ArchiveUsageTimeBasedSummary_ConsolidationLevel] ON [dbo].[ArchiveUsageTimeBasedSummary] DROP INDEX [IX_ConfingSettings_Key] ON [dbo].[ConfigSettings] ALTER TABLE [dbo].[ArchivePoint] DROP CONSTRAINT [UN_ArchivePointIdentity] DROP INDEX [IX_RefCountTotalCountIdPartitionFileFormatHSMType] ON [dbo].[Collection] DROP INDEX [IX_RelativeFileName_IdPartition_RefCount] ON [dbo].[Collection] DROP INDEX [IX_Collection_CreationDate] ON [dbo].[Collection] ALTER TABLE [dbo].[FSAVaultProperties] DROP CONSTRAINT [IX_FSAVaultProperties_VaultIdentity_HashAlgId] DROP INDEX [IX_SISPart_Sharing] ON [dbo].[SISPart] DROP INDEX [IX_HoldConsumerGUID] ON [dbo].[HoldConsumer] DROP INDEX [IX_Saveset_SISPart_SISPartIdentity] ON [dbo].[Saveset_SISPart] -- DROP INDEXES passes -- *** -- DROP PK ALTER TABLE [dbo].[Saveset_SISPart] DROP CONSTRAINT [PK_Saveset_SISPart] ALTER TABLE [dbo].[WatchSISPartFile] DROP CONSTRAINT [PK_WatchSISPartFile] ALTER TABLE [dbo].[JournalUpdate] DROP CONSTRAINT [PK_JournalUpdate] ALTER TABLE [dbo].[ArchivePoint] DROP CONSTRAINT [PK_ArchivePoint] ALTER TABLE [dbo].[Collection] DROP CONSTRAINT [PK_Collection] ALTER TABLE [dbo].[FSAVaultProperties] DROP CONSTRAINT [PK_FSAVaultProperties_1] ALTER TABLE [dbo].[JournalStub] DROP CONSTRAINT [PK_JournalStub] ALTER TABLE [dbo].[HoldConsumer] DROP CONSTRAINT [PK_HoldConsumer_1] ALTER TABLE [dbo].[HoldData] DROP CONSTRAINT [PK_HoldData_1] ALTER TABLE [dbo].[JournalDelete] DROP CONSTRAINT [PK_JournalDelete] ALTER TABLE [dbo].[JournalRestore] DROP CONSTRAINT [PK_JournalRestore] ALTER TABLE [dbo].[Saveset] DROP CONSTRAINT [PK_Saveset] ALTER TABLE [dbo].[SavesetProperty] DROP CONSTRAINT [PK_SavesetProperty] ALTER TABLE [dbo].[SavesetStore] DROP CONSTRAINT [PK_SavesetStore] ALTER TABLE [dbo].[Vault] DROP CONSTRAINT [PK_Vault] ALTER TABLE [dbo].[HoldGroup] DROP CONSTRAINT [PK_HoldGroup_1] ALTER TABLE [dbo].[UnrelatedArchiveVault] DROP CONSTRAINT [PK_UnrelatedArchiveVault] ALTER TABLE [dbo].[WatchFile] DROP CONSTRAINT [PK_WatchFile] ALTER TABLE [dbo].[HashAlgorithmInfo] DROP CONSTRAINT [PK_HashAlgorithmInfo] ALTER TABLE [dbo].[JournalArchive] DROP CONSTRAINT [PK_JournalArchive] ALTER TABLE [dbo].[VersionInfo] DROP CONSTRAINT [PK_VersionInfo] ALTER TABLE [dbo].[PartitionCache] DROP CONSTRAINT [PK_PartitionCache] ALTER TABLE [dbo].[ArchiveSummaryRetention] DROP CONSTRAINT [PK_ArchiveSummaryRetention] ALTER TABLE [dbo].[ArchiveSummary_Cache] DROP CONSTRAINT [PK_ArchiveSummary_Cache] ALTER TABLE [dbo].[ArchiveUsageSummary] DROP CONSTRAINT [PK_ArchiveUsageSummary] ALTER TABLE [dbo].[ArchiveUsageSummaryByFileType] DROP CONSTRAINT [PK_ArchiveUsageSummaryByFileType] ALTER TABLE [dbo].[ArchiveUsageTimeBasedSummary] DROP CONSTRAINT [PK_ArchiveUsageTimeBasedSummary] ALTER TABLE [dbo].[HoldSaveset] DROP CONSTRAINT [PK_HoldSaveset_SaveSet_HoldGroup] ALTER TABLE [dbo].[SISPart] DROP CONSTRAINT [PK_SISPartIdentity] -- DROP PK passed -- *** -- DROP COMPUTED COLUMNS -- DROP COMPUTED COLUMNS passed. -- *** -- GET BAD TABLES INFO -- GET BAD TABLE COLUMNS INFO -- --Special section for copying table start time: Feb 15 2012 11:19AM -- -- *** -- COPY TABLES FOR COMPUTED COLUMNS -- COPY TABLES FOR COMPUTED COLUMNS passed -- GET CHAR COLUMNS INFO -- --DROP section finish time: Feb 15 2012 11:19AM -- -- --Change collation section start time: Feb 15 2012 11:19AM -- -- ****************** -- TRY TO CHANGE COLLATION.... ALTER DATABASE EVExchangeArchiveStore1 COLLATE SQL_Latin1_General_CP1_CI_AS -- *** -- DB COLLATION HAS BEEN CHANGED SUCCESSFULLY -- *** -- COLUMNS COLLATION IN PROGRESS... ALTER TABLE [dbo].[HoldGroup] ALTER COLUMN [HoldUserGroupID] EVMoniker NOT NULL ALTER TABLE [dbo].[JournalArchive] ALTER COLUMN [SavesetID] EVSavesetID NOT NULL ALTER TABLE [dbo].[JournalArchive] ALTER COLUMN [ServiceEntryID] varchar(127) COLLATE DATABASE_DEFAULT NULL ALTER TABLE [dbo].[JournalArchive] ALTER COLUMN [ShortcutAccessor] text COLLATE DATABASE_DEFAULT NULL ALTER TABLE [dbo].[JournalArchive] ALTER COLUMN [Location] text COLLATE DATABASE_DEFAULT NULL ALTER TABLE [dbo].[JournalArchive] ALTER COLUMN [VaultID] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalDelete] ALTER COLUMN [SavesetID] EVSavesetID NOT NULL ALTER TABLE [dbo].[JournalDelete] ALTER COLUMN [ArchiveId] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalDelete] ALTER COLUMN [VaultId] EVVaultID NOT NULL ALTER TABLE [dbo].[WatchSISPartFile] ALTER COLUMN [StoreIdentifier] EVCenteraClip2 NULL ALTER TABLE [dbo].[JournalRestore] ALTER COLUMN [TransactionID] EVRestoreTransactionID NOT NULL ALTER TABLE [dbo].[JournalRestore] ALTER COLUMN [SavesetID] EVSavesetID NOT NULL ALTER TABLE [dbo].[JournalRestore] ALTER COLUMN [VaultID] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalUpdate] ALTER COLUMN [SavesetId] EVSavesetID NOT NULL ALTER TABLE [dbo].[JournalUpdate] ALTER COLUMN [ArchivePointId] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalUpdate] ALTER COLUMN [CurrentArchiveFolderId] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalUpdate] ALTER COLUMN [NewArchiveFolderId] EVVaultID NOT NULL ALTER TABLE [dbo].[SavesetProperty] ALTER COLUMN [ItemId] EVPropertyId NULL ALTER TABLE [dbo].[SavesetProperty] ALTER COLUMN [Properties] EVProperties NULL ALTER TABLE [dbo].[SavesetStore] ALTER COLUMN [StoreIdentifier] EVStoreIdentifier NOT NULL ALTER TABLE [dbo].[Vault] ALTER COLUMN [VaultID] EVVaultID NOT NULL ALTER TABLE [dbo].[WatchFile] ALTER COLUMN [ItemName] EVItemName NOT NULL ALTER TABLE [dbo].[JournalStub] ALTER COLUMN [VaultId] EVVaultID NOT NULL ALTER TABLE [dbo].[JournalStub] ALTER COLUMN [Payload] text COLLATE DATABASE_DEFAULT NOT NULL ALTER TABLE [dbo].[UnrelatedArchiveVault] ALTER COLUMN [ArchiveEntryId] varchar(127) COLLATE DATABASE_DEFAULT NOT NULL ALTER TABLE [dbo].[UnrelatedArchiveVault] ALTER COLUMN [VaultEntryId] varchar(127) COLLATE DATABASE_DEFAULT NOT NULL ALTER TABLE [dbo].[HashAlgorithmInfo] ALTER COLUMN [HashAlgName] nvarchar(50) COLLATE DATABASE_DEFAULT NULL ALTER TABLE [dbo].[ConfigSettings] ALTER COLUMN [Key] varchar(50) COLLATE DATABASE_DEFAULT NOT NULL ALTER TABLE [dbo].[ConfigSettings] ALTER COLUMN [Value] varchar(250) COLLATE DATABASE_DEFAULT NOT NULL ALTER TABLE [dbo].[ConfigSettings] ALTER COLUMN [Description] nvarchar(max) COLLATE DATABASE_DEFAULT NULL ALTER TABLE [dbo].[ArchivePoint] ALTER COLUMN [ArchivePointId] EVVaultID NOT NULL ALTER TABLE [dbo].[Collection] ALTER COLUMN [RelativeFileName] EVPath NULL ALTER TABLE [dbo].[Collection] ALTER COLUMN [FileFormat] EVFileFormat NULL ALTER TABLE [dbo].[Collection] ALTER COLUMN [MigratedFileId] EVMoniker NULL ALTER TABLE [dbo].[HoldData] ALTER COLUMN [HoldMetadata] ntext COLLATE DATABASE_DEFAULT NULL -- *** -- CHANGING COLUMNS COLLATION - done! -- --Change collation section end time: Feb 15 2012 11:32AM -- -- --Restore bad tables section start time: Feb 15 2012 11:32AM -- -- *** -- RESTORING BAD TABLES -- RESTORING TABLES FOR COMPUTED COLUMNS passed -- --Restore bad tables section end time: Feb 15 2012 11:32AM -- -- *** -- RE-CREATE COMPUTED COLUMNS -- RE-CREATE COMPUTED COLUMNS passed -- *** -- CREATE PRIMARY KEY CONSTRAINTS ALTER TABLE [dbo].[ArchivePoint] ADD CONSTRAINT [PK_ArchivePoint] PRIMARY KEY CLUSTERED ([ArchivePointId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[ArchiveSummary_Cache] ADD CONSTRAINT [PK_ArchiveSummary_Cache] PRIMARY KEY CLUSTERED ([ArchiveSummaryIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[ArchiveSummaryRetention] ADD CONSTRAINT [PK_ArchiveSummaryRetention] PRIMARY KEY CLUSTERED ([ConsolidationLevel] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[ArchiveUsageSummary] ADD CONSTRAINT [PK_ArchiveUsageSummary] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[ArchiveUsageSummaryByFileType] ADD CONSTRAINT [PK_ArchiveUsageSummaryByFileType] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC,[FileTypeID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[ArchiveUsageTimeBasedSummary] ADD CONSTRAINT [PK_ArchiveUsageTimeBasedSummary] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC,[ArchivedDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[Collection] ADD CONSTRAINT [PK_Collection] PRIMARY KEY CLUSTERED ([CollectionIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[FSAVaultProperties] ADD CONSTRAINT [PK_FSAVaultProperties_1] PRIMARY KEY CLUSTERED ([VaultIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[HashAlgorithmInfo] ADD CONSTRAINT [PK_HashAlgorithmInfo] PRIMARY KEY CLUSTERED ([HashAlgId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[HoldConsumer] ADD CONSTRAINT [PK_HoldConsumer_1] PRIMARY KEY CLUSTERED ([HoldConsumerIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[HoldData] ADD CONSTRAINT [PK_HoldData_1] PRIMARY KEY CLUSTERED ([HoldDataIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[HoldGroup] ADD CONSTRAINT [PK_HoldGroup_1] PRIMARY KEY NONCLUSTERED ([HoldGroupIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[HoldSaveset] ADD CONSTRAINT [PK_HoldSaveset_SaveSet_HoldGroup] PRIMARY KEY CLUSTERED ([SavesetIdentity] ASC,[HoldGroupIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=ON, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=70) ON [PRIMARY] ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [PK_JournalArchive] PRIMARY KEY NONCLUSTERED ([TransactionID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[JournalDelete] ADD CONSTRAINT [PK_JournalDelete] PRIMARY KEY CLUSTERED ([SavesetID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[JournalRestore] ADD CONSTRAINT [PK_JournalRestore] PRIMARY KEY CLUSTERED ([TransactionID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[JournalStub] ADD CONSTRAINT [PK_JournalStub] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC,[ItemSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[JournalUpdate] ADD CONSTRAINT [PK_JournalUpdate] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC,[ItemSeqNo] ASC,[UpdateSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[PartitionCache] ADD CONSTRAINT [PK_PartitionCache] PRIMARY KEY CLUSTERED ([IdPartition] ASC,[VaultStoreIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[Saveset] ADD CONSTRAINT [PK_Saveset] PRIMARY KEY CLUSTERED ([ArchivePointIdentity] ASC,[IndexSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[Saveset_SISPart] ADD CONSTRAINT [PK_Saveset_SISPart] PRIMARY KEY CLUSTERED ([SavesetIdentity] ASC,[SISPartIdentity] ASC,[AttachmentId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[SavesetProperty] ADD CONSTRAINT [PK_SavesetProperty] PRIMARY KEY CLUSTERED ([SavesetIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[SavesetStore] ADD CONSTRAINT [PK_SavesetStore] PRIMARY KEY CLUSTERED ([SavesetIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[SISPart] ADD CONSTRAINT [PK_SISPartIdentity] PRIMARY KEY CLUSTERED ([SISPartIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[UnrelatedArchiveVault] ADD CONSTRAINT [PK_UnrelatedArchiveVault] PRIMARY KEY CLUSTERED ([ArchiveEntryId] ASC,[VaultEntryId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[Vault] ADD CONSTRAINT [PK_Vault] PRIMARY KEY CLUSTERED ([VaultID] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=80) ON [PRIMARY] ALTER TABLE [dbo].[VersionInfo] ADD CONSTRAINT [PK_VersionInfo] PRIMARY KEY NONCLUSTERED ([MigrationVersion] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[WatchFile] ADD CONSTRAINT [PK_WatchFile] PRIMARY KEY NONCLUSTERED ([ArchiveTransactionId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[WatchSISPartFile] ADD CONSTRAINT [PK_WatchSISPartFile] PRIMARY KEY CLUSTERED ([SavesetIdentity] ASC,[SISPartIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] -- CREATE PRIMARY KEY CONSTRAINTS passed -- *** -- CREATE DEFAULT CONSTRAINTS ALTER TABLE [dbo].[ArchivePoint] ADD CONSTRAINT [DF_ArchivePoint_IndexUpdatesPending] DEFAULT ((0)) FOR [IndexUpdatesPending] ALTER TABLE [dbo].[JournalUpdate] ADD CONSTRAINT [DF_JournalUpdate_IndexCommitted] DEFAULT ((0)) FOR [IndexCommitted] ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [DF__JournalAr__Recor__0A688BB1] DEFAULT (getutcdate()) FOR [RecordCreationDate] ALTER TABLE [dbo].[WatchFile] ADD CONSTRAINT [DF_ItemSecured_WatchFile] DEFAULT ((0)) FOR [ItemSecured] ALTER TABLE [dbo].[JournalStub] ADD CONSTRAINT [DF_JournalStub_RecordCreationDate] DEFAULT (getutcdate()) FOR [RecordCreationDate] ALTER TABLE [dbo].[SISPart] ADD CONSTRAINT [DF__SISPart__LargeFi__11158940] DEFAULT ((0)) FOR [LargeFile] ALTER TABLE [dbo].[SISPart] ADD CONSTRAINT [DF_FPVersion_SISPart] DEFAULT ((1)) FOR [FPVersion] ALTER TABLE [dbo].[WatchSISPartFile] ADD CONSTRAINT [DF_FPVersion_WatchSISPartFile] DEFAULT ((1)) FOR [FPVersion] ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [DF_DeleteFailedWFItem_JournalArchive] DEFAULT ((0)) FOR [DeleteFailedWFItem] ALTER TABLE [dbo].[WatchSISPartFile] ADD CONSTRAINT [DF_LargeFile_WatchSISPartFile] DEFAULT ((0)) FOR [LargeFile] ALTER TABLE [dbo].[JournalDelete] ADD CONSTRAINT [DF__JournalDe__Delet__151B244E] DEFAULT ((1)) FOR [DeletionStatus] ALTER TABLE [dbo].[ArchivePoint] ADD CONSTRAINT [DF_HighestPurgedJournalSeqNo_ArchivePoint] DEFAULT ((0)) FOR [HighestPurgedJournalSeqNo] ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [DF_RemoveSafetyCopy_JournalArchive] DEFAULT ((0)) FOR [RemoveSafetyCopy] ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [DF_OnPrimaryDevice_JournalArchive] DEFAULT ((1)) FOR [OnPrimaryDevice] ALTER TABLE [dbo].[WatchFile] ADD CONSTRAINT [DF_LargeFile_WatchFile] DEFAULT ((0)) FOR [LargeFile] ALTER TABLE [dbo].[JournalDelete] ADD CONSTRAINT [DF_JournalDelete_IndexCommitted] DEFAULT ((0)) FOR [IndexCommitted] ALTER TABLE [dbo].[WatchFile] ADD CONSTRAINT [DF__WatchFile__ItemI__347EC10E] DEFAULT ((0)) FOR [ItemInvalid] ALTER TABLE [dbo].[JournalDelete] ADD CONSTRAINT [DF_JournalDelete_DeletionDate] DEFAULT (getutcdate()) FOR [DeletionDate] ALTER TABLE [dbo].[WatchSISPartFile] ADD CONSTRAINT [DF__WatchSISP__ItemI__3572E547] DEFAULT ((0)) FOR [ItemInvalid] ALTER TABLE [dbo].[Vault] ADD CONSTRAINT [DF_Vault_DeletionRunDate] DEFAULT ('17530101') FOR [DeletionRunDate] ALTER TABLE [dbo].[ArchiveSummary] ADD CONSTRAINT [DF_ArchiveSummary_RefCount] DEFAULT ((1)) FOR [RefCount] ALTER TABLE [dbo].[ArchiveSummary] ADD CONSTRAINT [DF_ArchiveSummary_IsFSA] DEFAULT ((0)) FOR [IsFSA] ALTER TABLE [dbo].[ArchiveSummary] ADD CONSTRAINT [DF_ArchiveSummary_IncludeInTimeSummaries] DEFAULT ((1)) FOR [IncludeInTimeSummaries] ALTER TABLE [dbo].[ArchiveSummary] ADD CONSTRAINT [DF_ArchiveSummary_MissingOriginalSizeRefCount] DEFAULT ((0)) FOR [MissingOriginalSizeRefCount] ALTER TABLE [dbo].[ArchiveUsageTimeBasedSummary] ADD CONSTRAINT [DF_ArchiveUsageTimeBasedSummary_ConsolidationLevel] DEFAULT ((0)) FOR [ConsolidationLevel] ALTER TABLE [dbo].[ConfigSettings] ADD CONSTRAINT [DF_ConfigSettings_LastModifiedDate] DEFAULT (getutcdate()) FOR [LastModifiedDate] -- CREATE DEFAULT CONSTRAINTS passed -- *** -- CREATE CHECK CONSTRAINTS -- CREATE CHECK CONSTRAINTS passed -- *** -- CREATE INDEXES ALTER TABLE [dbo].[ArchivePoint] ADD CONSTRAINT [UN_ArchivePointIdentity] UNIQUE NONCLUSTERED ([ArchivePointIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ArchiveSummaryCache_ArchivePointIdentity_ArchivedDate] ON [dbo].[ArchiveSummary_Cache] ([ArchivePointIdentity] ASC,[ArchivedDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ArchiveSummaryCache_ArchivePointIdentity_FileTypeID] ON [dbo].[ArchiveSummary_Cache] ([ArchivePointIdentity] ASC,[FileTypeID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ArchiveUsageTimeBasedSummary_ArchivedDate] ON [dbo].[ArchiveUsageTimeBasedSummary] ([OriginalSize] ASC,[ArchivedItemSize] ASC,[TotalArchivedItems] ASC,[ConsolidationLevel] ASC,[ArchivedDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ArchiveUsageTimeBasedSummary_ConsolidationLevel] ON [dbo].[ArchiveUsageTimeBasedSummary] ([OriginalSize] ASC,[ArchivedItemSize] ASC,[TotalArchivedItems] ASC,[ConsolidationLevel] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Collection_CreationDate] ON [dbo].[Collection] ([IdPartition] ASC,[CreationDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_RefCountTotalCountIdPartitionFileFormatHSMType] ON [dbo].[Collection] ([RefCount] ASC,[TotalCount] ASC,[IdPartition] ASC,[FileFormat] ASC,[HSMType] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=25) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_RelativeFileName_IdPartition_RefCount] ON [dbo].[Collection] ([RelativeFileName] ASC,[IdPartition] ASC,[RefCount] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=25) ON [PRIMARY] CREATE UNIQUE NONCLUSTERED INDEX [IX_ConfingSettings_Key] ON [dbo].[ConfigSettings] ([Key] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=ON, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[FSAVaultProperties] ADD CONSTRAINT [IX_FSAVaultProperties_VaultIdentity_HashAlgId] UNIQUE NONCLUSTERED ([VaultIdentity] ASC,[HashAlgId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE UNIQUE NONCLUSTERED INDEX [IX_HoldConsumerGUID] ON [dbo].[HoldConsumer] ([HoldConsumerGUID] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_HoldGroup_HoldConsumerIdentity] ON [dbo].[HoldGroup] ([HoldConsumerIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE CLUSTERED INDEX [IX_HoldGroup_HoldUserGroupID_HoldConsumerIdentity] ON [dbo].[HoldGroup] ([HoldUserGroupID] ASC,[HoldConsumerIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_HoldSaveset_ArchivePointIdentity] ON [dbo].[HoldSaveset] ([ArchivePointIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_HoldSaveset_HGID_HDID] ON [dbo].[HoldSaveset] ([HoldGroupIdentity] ASC,[HoldDataIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_HoldSaveset_HoldDataIdentity] ON [dbo].[HoldSaveset] ([HoldDataIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_HoldSaveset_SSID_HGID_HID] ON [dbo].[HoldSaveset] ([SavesetIdentity] ASC,[HoldGroupIdentity] ASC,[HoldIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JA_ArchivePointIdentity_IndexSeqNo_BackupComplete_IndexCommited] ON [dbo].[JournalArchive] ([ArchivePointIdentity] ASC,[IndexSeqNo] ASC,[BackupComplete] ASC,[IndexCommited] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JA_VaultIdentity] ON [dbo].[JournalArchive] ([VaultIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalArchive_ArchivePointIdentity_IndexCommited] ON [dbo].[JournalArchive] ([ArchivePointIdentity] ASC,[IndexCommited] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalArchive_IdPartition] ON [dbo].[JournalArchive] ([IdPartition] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE UNIQUE CLUSTERED INDEX [IX_JournalArchive_SavesetIdentity] ON [dbo].[JournalArchive] ([SavesetIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JD_ArchivePointIdentity_ItemSeqNo2] ON [dbo].[JournalDelete] ([IndexCommitted] ASC,[DeletionStatus] ASC,[ArchivePointIdentity] ASC,[IndexSeqNo] ASC,[ItemSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=50) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JD_DeletionStatus] ON [dbo].[JournalDelete] ([DeletionStatus] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=75) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalDelete_DR_VI_VID] ON [dbo].[JournalDelete] ([DeletionReason] ASC,[VaultIdentity] ASC,[VaultId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=50) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalDelete_IC_DD] ON [dbo].[JournalDelete] ([IndexCommitted] ASC,[DeletionDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_VaultIdentity] ON [dbo].[JournalDelete] ([VaultIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalStub_RecordCreationDate] ON [dbo].[JournalStub] ([RecordCreationDate] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalStub_Sensitivity] ON [dbo].[JournalStub] ([Sensitivity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalStub_VaultId_ItemSeqNo] ON [dbo].[JournalStub] ([VaultId] ASC,[ItemSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] ALTER TABLE [dbo].[JournalUpdate] ADD CONSTRAINT [IX_JournalUpdate_APIdent_USN] UNIQUE NONCLUSTERED ([ArchivePointIdentity] ASC,[UpdateSeqNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_JournalUpdate_NewArchiveFolderIdentity] ON [dbo].[JournalUpdate] ([NewArchiveFolderIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Collection_Saveset_Partition] ON [dbo].[Saveset] ([CollectionIdentity] ASC,[SavesetIdentity] ASC,[IdPartition] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=80) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_IdDateTime] ON [dbo].[Saveset] ([IdDateTime] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE UNIQUE NONCLUSTERED INDEX [IX_IdTransaction] ON [dbo].[Saveset] ([IdTransaction] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Saveset_CollectionIdentity] ON [dbo].[Saveset] ([CollectionIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Saveset_VaultIdentity] ON [dbo].[Saveset] ([VaultIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=80) ON [PRIMARY] ALTER TABLE [dbo].[Saveset] ADD CONSTRAINT [UN_SavesetIdentity] UNIQUE NONCLUSTERED ([SavesetIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Saveset_SISPart_SISPartIdentity] ON [dbo].[Saveset_SISPart] ([SISPartIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ItemId_Qualifier] ON [dbo].[SavesetProperty] ([ItemId] ASC,[Qualifier] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=50) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_SISPart_Sharing] ON [dbo].[SISPart] ([FPDistinctionByte] ASC,[FPHashPart1] ASC,[ParentTransactionId] ASC,[VaultStoreIdentity] ASC,[IdPartition] ASC,[UniqueId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=50) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_Vault_ArchivePointIdentity] ON [dbo].[Vault] ([ArchivePointIdentity] ASC) WITH (PAD_INDEX=ON, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON, FILLFACTOR=80) ON [PRIMARY] ALTER TABLE [dbo].[Vault] ADD CONSTRAINT [UN_VaultIdentity] UNIQUE NONCLUSTERED ([VaultIdentity] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_IdPartition_ItemName_SequenceNumber] ON [dbo].[WatchFile] ([IdPartition] ASC,[ItemName] ASC,[SequenceNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_ItemName_ArchiveTransactionId] ON [dbo].[WatchFile] ([ItemName] ASC,[ArchiveTransactionId] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] CREATE CLUSTERED INDEX [IX_SequenceNo1] ON [dbo].[WatchFile] ([SequenceNo] ASC) WITH (PAD_INDEX=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] -- CREATE INDEXES passed -- *** -- CREATE FK CONSTRAINTS ALTER TABLE [dbo].[FSAVaultProperties] ADD CONSTRAINT [CONS_FK_Vault_FSAVaultProperties] FOREIGN KEY ([VaultIdentity]) REFERENCES [dbo].[Vault] ([VaultIdentity]) ON DELETE CASCADE ALTER TABLE [dbo].[JournalUpdate] ADD CONSTRAINT [FK_ArchiveFolderIdentity_JournalUpdate] FOREIGN KEY ([NewArchiveFolderIdentity]) REFERENCES [dbo].[Vault] ([VaultIdentity]) ALTER TABLE [dbo].[HoldSaveset] ADD CONSTRAINT [FK_ArchivePointIdentity_HoldSaveset] FOREIGN KEY ([ArchivePointIdentity]) REFERENCES [dbo].[ArchivePoint] ([ArchivePointIdentity]) ALTER TABLE [dbo].[JournalStub] ADD CONSTRAINT [FK_ArchivePointIdentity_JournalStub] FOREIGN KEY ([ArchivePointIdentity]) REFERENCES [dbo].[ArchivePoint] ([ArchivePointIdentity]) ALTER TABLE [dbo].[Vault] ADD CONSTRAINT [FK_ArchivePointIdentity_Vault] FOREIGN KEY ([ArchivePointIdentity]) REFERENCES [dbo].[ArchivePoint] ([ArchivePointIdentity]) ALTER TABLE [dbo].[Saveset] ADD CONSTRAINT [FK_CollectionIdentity_Collection] FOREIGN KEY ([CollectionIdentity]) REFERENCES [dbo].[Collection] ([CollectionIdentity]) ALTER TABLE [dbo].[FSAVaultProperties] ADD CONSTRAINT [FK_HashAlgorithmInfo_FSAVaultProperties] FOREIGN KEY ([HashAlgId]) REFERENCES [dbo].[HashAlgorithmInfo] ([HashAlgId]) ALTER TABLE [dbo].[HoldGroup] ADD CONSTRAINT [FK_HoldConsumerIdentity_HoldGroup] FOREIGN KEY ([HoldConsumerIdentity]) REFERENCES [dbo].[HoldConsumer] ([HoldConsumerIdentity]) ALTER TABLE [dbo].[HoldSaveset] ADD CONSTRAINT [FK_HoldData_HoldSaveset] FOREIGN KEY ([HoldDataIdentity]) REFERENCES [dbo].[HoldData] ([HoldDataIdentity]) ALTER TABLE [dbo].[HoldSaveset] ADD CONSTRAINT [FK_HoldGroupIdentity_HoldSaveset] FOREIGN KEY ([HoldGroupIdentity]) REFERENCES [dbo].[HoldGroup] ([HoldGroupIdentity]) ALTER TABLE [dbo].[JournalArchive] ADD CONSTRAINT [FK_JournalArchive_Saveset] FOREIGN KEY ([TransactionID]) REFERENCES [dbo].[Saveset] ([IdTransaction]) ALTER TABLE [dbo].[JournalRestore] ADD CONSTRAINT [FK_JournalRestore_VaultID] FOREIGN KEY ([VaultID]) REFERENCES [dbo].[Vault] ([VaultID]) ALTER TABLE [dbo].[Saveset_SISPart] ADD CONSTRAINT [FK_Saveset_SISPart_Saveset] FOREIGN KEY ([SavesetIdentity]) REFERENCES [dbo].[Saveset] ([SavesetIdentity]) ALTER TABLE [dbo].[Saveset_SISPart] ADD CONSTRAINT [FK_Saveset_SISPart_SISPart] FOREIGN KEY ([SISPartIdentity]) REFERENCES [dbo].[SISPart] ([SISPartIdentity]) ALTER TABLE [dbo].[HoldSaveset] ADD CONSTRAINT [FK_SavesetIdentity_HoldSaveset] FOREIGN KEY ([SavesetIdentity]) REFERENCES [dbo].[Saveset] ([SavesetIdentity]) ALTER TABLE [dbo].[SavesetProperty] ADD CONSTRAINT [FK_SavesetIdentity_SavesetProperty] FOREIGN KEY ([SavesetIdentity]) REFERENCES [dbo].[Saveset] ([SavesetIdentity]) Msg 547, Level 16, State 0, Line 1 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_SavesetIdentity_SavesetProperty". The conflict occurred in database "EVExchangeArchiveStore1", table "dbo.Saveset", column 'SavesetIdentity'.