--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'.