December 1, 2016 at 3:00 am
Scenario
Moving database from:
Microsoft SQL Server 2008 (SP4) - 10.0.6241.0 (X64) Apr 17 2015 10:56:08 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
to:
Microsoft SQL Server 2016 (RTM-GDR) (KB3194716) - 13.0.1722.0 (X64) Sep 26 2016 13:17:23 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)
The database VoruhusGagna is about 620 GB in size. It is TDE encrypted and we have already restored the appropriate thumbprint.
We will restore full backup with norecovery and then ship logs until official deployment day.
Testing/restoring the full backup/log backup with norecovery succeeds.
Testing/restoring the full backup/log backup with recovery fails with the following message:
Msg 608, Level 16, State 1, Line 64
No catalog entry found for partition ID 281474978217984 in database 10. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.
Msg 3167, Level 16, State 1, Line 64
RESTORE could not start database 'VoruhusGagna'.
Msg 3013, Level 16, State 1, Line 64
RESTORE DATABASE is terminating abnormally.
As suggested I ran the following on the production database
DBCC CHECKDB ( [VoruhusGagna] ) ;
resulting in:
/*
DBCC results for 'VoruhusGagna'.
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.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 2744 rows in 84 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 266 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 280 rows in 4 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 25 rows in 4 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 25 rows in 2 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 21 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 152 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 337 rows in 9 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2340 rows in 55 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 1382 rows in 39 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 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 1315 rows in 33 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 1695 rows in 13 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.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 1321 rows in 758 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 28 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 335 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 805 rows in 8 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 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 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 124 rows in 4 pages for object "sys.syssoftobjrefs".
DBCC results for 'di_writer.DIM_SOURCE_TABLE'.
There are 9 rows in 1 pages for object "di_writer.DIM_SOURCE_TABLE".
DBCC results for 'di_writer.DIM_ER_KORT'.
There are 15621978 rows in 87107 pages for object "di_writer.DIM_ER_KORT".
DBCC results for 'di_writer.FACT_ER_UPPGJOR'.
There are 23962688 rows in 465776 pages for object "di_writer.FACT_ER_UPPGJOR".
DBCC results for 'di_writer.FACT_EI_KORTAFAERSLA'.
There are 105727260 rows in 2390607 pages for object "di_writer.FACT_EI_KORTAFAERSLA".
DBCC results for 'di_writer.DIM_CLEARING_FILE'.
There are 6606 rows in 41 pages for object "di_writer.DIM_CLEARING_FILE".
DBCC results for 'di_writer.DIM_UPPGJORSMANUDUR'.
There are 204 rows in 2 pages for object "di_writer.DIM_UPPGJORSMANUDUR".
DBCC results for 'export.TransactionLog'.
There are 102914 rows in 4726 pages for object "export.TransactionLog".
DBCC results for 'di_writer.FACT_EI_FAERSLA'.
There are 17870514 rows in 338646 pages for object "di_writer.FACT_EI_FAERSLA".
DBCC results for 'di_writer.DIM_FRAUDTYPE'.
There are 27 rows in 1 pages for object "di_writer.DIM_FRAUDTYPE".
DBCC results for 'di_writer.DIM_ASTANDSKODAR'.
There are 31 rows in 1 pages for object "di_writer.DIM_ASTANDSKODAR".
DBCC results for 'di_writer.DIM_DA_KORT_OLD'.
There are 3880030 rows in 19696 pages for object "di_writer.DIM_DA_KORT_OLD".
DBCC results for 'di_writer.FACT_MC_TR'.
There are 70268979 rows in 1485558 pages for object "di_writer.FACT_MC_TR".
DBCC results for 'di_writer.DIM_BIN'.
There are 525043 rows in 2012 pages for object "di_writer.DIM_BIN".
DBCC results for 'di_writer.FACT_CostSettings'.
There are 2352 rows in 29 pages for object "di_writer.FACT_CostSettings".
DBCC results for 'di_writer.DIM_LAND'.
There are 253 rows in 5 pages for object "di_writer.DIM_LAND".
DBCC results for 'di_writer.BANKAUTIBU_DIM'.
There are 216 rows in 4 pages for object "di_writer.BANKAUTIBU_DIM".
DBCC results for 'di_writer.DIM_DEILD'.
There are 11 rows in 1 pages for object "di_writer.DIM_DEILD".
DBCC results for 'di_writer.FLOKKUR_SU_DIM'.
There are 69 rows in 1 pages for object "di_writer.FLOKKUR_SU_DIM".
DBCC results for 'di_writer.DIM_AAETLUN'.
There are 47 rows in 1 pages for object "di_writer.DIM_AAETLUN".
DBCC results for 'di_writer.DIM_INVOICE_TEXT'.
There are 8 rows in 1 pages for object "di_writer.DIM_INVOICE_TEXT".
DBCC results for 'di_writer.BIN_DIM'.
There are 5 rows in 2 pages for object "di_writer.BIN_DIM".
DBCC results for 'di_writer.Audit_df'.
There are 1 rows in 1 pages for object "di_writer.Audit_df".
DBCC results for 'di_writer.DA_GJALDSKRA_FAST'.
There are 58900 rows in 578 pages for object "di_writer.DA_GJALDSKRA_FAST".
DBCC results for 'di_writer.DIM_UMDAEMI'.
There are 112 rows in 1 pages for object "di_writer.DIM_UMDAEMI".
DBCC results for 'di_writer.Audit_Table'.
There are 44435 rows in 557 pages for object "di_writer.Audit_Table".
DBCC results for 'di_writer.DA_GJALDSKRA_PROS'.
There are 181543 rows in 3080 pages for object "di_writer.DA_GJALDSKRA_PROS".
DBCC results for 'di_writer.DA_TAEKJASKRA'.
There are 8913 rows in 163 pages for object "di_writer.DA_TAEKJASKRA".
DBCC results for 'di_writer.DA_VERSLANIR'.
There are 36997 rows in 379 pages for object "di_writer.DA_VERSLANIR".
DBCC results for 'di_writer.FACT_AAETLUN'.
There are 27740 rows in 151 pages for object "di_writer.FACT_AAETLUN".
DBCC results for 'di_writer.DIM_ACQUIRER'.
There are 5 rows in 2 pages for object "di_writer.DIM_ACQUIRER".
DBCC results for 'export.GetTransactionStripe'.
There are 2073480 rows in 79761 pages for object "export.GetTransactionStripe".
DBCC results for 'di_writer.FACT_DA_DAGL_UPPGJOR'.
There are 10205500 rows in 148464 pages for object "di_writer.FACT_DA_DAGL_UPPGJOR".
DBCC results for 'di_writer.FACT_DA_SUNDL_UPPGJ'.
There are 5148775 rows in 34698 pages for object "di_writer.FACT_DA_SUNDL_UPPGJ".
DBCC results for 'di_writer.FACT_DA_UPPGJOR'.
There are 485295 rows in 9177 pages for object "di_writer.FACT_DA_UPPGJOR".
DBCC results for 'di_writer.SAMNINGA_DIM'.
There are 58845 rows in 1268 pages for object "di_writer.SAMNINGA_DIM".
DBCC results for 'di_writer.SOLUADILI_DIM'.
There are 45935 rows in 1342 pages for object "di_writer.SOLUADILI_DIM".
DBCC results for 'di_writer.DIM_MCC'.
There are 857 rows in 10 pages for object "di_writer.DIM_MCC".
DBCC results for 'di_writer.STADUR_DIM'.
There are 161 rows in 2 pages for object "di_writer.STADUR_DIM".
DBCC results for 'di_writer.DIM_DA_KORT'.
There are 4068418 rows in 22729 pages for object "di_writer.DIM_DA_KORT".
DBCC results for 'di_writer.TEGUND_SAMNINGS_DIM'.
There are 18 rows in 1 pages for object "di_writer.TEGUND_SAMNINGS_DIM".
DBCC results for 'di_writer.DIM_TRANSTYPE'.
There are 56 rows in 1 pages for object "di_writer.DIM_TRANSTYPE".
DBCC results for 'di_writer.UPPGJORSMANUDUR_DIM'.
There are 205 rows in 3 pages for object "di_writer.UPPGJORSMANUDUR_DIM".
DBCC results for 'temp_audit_table_20160127'.
There are 8 rows in 2 pages for object "temp_audit_table_20160127".
DBCC results for 'temp_audit_table_20160128'.
There are 8 rows in 2 pages for object "temp_audit_table_20160128".
DBCC results for 'di_writer.DIM_DATE'.
There are 14612 rows in 197 pages for object "di_writer.DIM_DATE".
DBCC results for 'di_writer.DIM_ROLE'.
There are 6 rows in 1 pages for object "di_writer.DIM_ROLE".
DBCC results for 'temp_audit_table_20160129'.
There are 8 rows in 2 pages for object "temp_audit_table_20160129".
DBCC results for 'temp_audit_table_20160201'.
There are 8 rows in 2 pages for object "temp_audit_table_20160201".
DBCC results for 'di_writer.DIM_MESSAGE_DATARECORD_CODE'.
There are 66 rows in 1 pages for object "di_writer.DIM_MESSAGE_DATARECORD_CODE".
DBCC results for 'di_writer.DIM_SOLUADILI'.
There are 10982 rows in 952 pages for object "di_writer.DIM_SOLUADILI".
DBCC results for 'di_writer.DIM_MESSAGE_FUNCTION_CODE'.
There are 27 rows in 1 pages for object "di_writer.DIM_MESSAGE_FUNCTION_CODE".
DBCC results for 'di_writer.DIM_MESSAGE_PROCESSING_CODE'.
There are 85 rows in 2 pages for object "di_writer.DIM_MESSAGE_PROCESSING_CODE".
DBCC results for 'di_writer.DIM_PARTNER'.
There are 135 rows in 8 pages for object "di_writer.DIM_PARTNER".
DBCC results for 'di_writer.DIM_ISSUER'.
There are 8800 rows in 167 pages for object "di_writer.DIM_ISSUER".
DBCC results for 'di_writer.FACT_MC_MESSAGE'.
There are 12009 rows in 446 pages for object "di_writer.FACT_MC_MESSAGE".
DBCC results for 'di_writer.FACT_INVOICE'.
There are 4170 rows in 98 pages for object "di_writer.FACT_INVOICE".
DBCC results for 'di_writer.DIM_SAMNINGUR'.
There are 27606 rows in 2276 pages for object "di_writer.DIM_SAMNINGUR".
DBCC results for 'di_writer.FACT_PARTNER_ROLE'.
There are 168 rows in 2 pages for object "di_writer.FACT_PARTNER_ROLE".
DBCC results for 'di_writer.FACT_ER_FAERSLA'.
There are 29189478 rows in 7251452 pages for object "di_writer.FACT_ER_FAERSLA".
DBCC results for 'di_writer.DIM_CARDUSAGE'.
There are 5 rows in 1 pages for object "di_writer.DIM_CARDUSAGE".
DBCC results for 'di_writer.DIM_ER_KORT_OLD'.
There are 15890439 rows in 80664 pages for object "di_writer.DIM_ER_KORT_OLD".
DBCC results for 'di_writer.DIM_AGENT_COMM'.
There are 406469 rows in 12655 pages for object "di_writer.DIM_AGENT_COMM".
DBCC results for 'sys.filestream_tombstone_1389964028'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_1389964028".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'di_writer.FACT_DADE_ACQUIRER_SUM'.
There are 3636173 rows in 47208 pages for object "di_writer.FACT_DADE_ACQUIRER_SUM".
DBCC results for 'di_writer.DIM_VISA_MC'.
There are 5 rows in 1 pages for object "di_writer.DIM_VISA_MC".
DBCC results for 'di_writer.FACT_DADE_FAERSLA'.
There are 117640953 rows in 1952658 pages for object "di_writer.FACT_DADE_FAERSLA".
DBCC results for 'di_writer.DIM_UMBODSMADUR'.
There are 30 rows in 1 pages for object "di_writer.DIM_UMBODSMADUR".
DBCC results for 'di_writer.DIM_ATVINNUGREIN'.
There are 28 rows in 1 pages for object "di_writer.DIM_ATVINNUGREIN".
DBCC results for 'di_writer.FACT_GREIDSLUSKRA_AGENT'.
There are 5298 rows in 75 pages for object "di_writer.FACT_GREIDSLUSKRA_AGENT".
DBCC results for 'updsc1.DIM_UNDIR_SOLUADILI'.
There are 23 rows in 2 pages for object "updsc1.DIM_UNDIR_SOLUADILI".
DBCC results for 'di_writer.DIM_UNDIR_SOLUADILI'.
There are 46087 rows in 1794 pages for object "di_writer.DIM_UNDIR_SOLUADILI".
DBCC results for 'di_writer.FACT_ER_KORTAFAERSLA'.
There are 193132891 rows in 16061022 pages for object "di_writer.FACT_ER_KORTAFAERSLA".
DBCC results for 'upddel.DIM_UNDIR_SOLUADILI'.
There are 0 rows in 0 pages for object "upddel.DIM_UNDIR_SOLUADILI".
DBCC results for 'updexp.DIM_UNDIR_SOLUADILI'.
There are 3 rows in 2 pages for object "updexp.DIM_UNDIR_SOLUADILI".
DBCC results for 'updsc1.DIM_SOLUADILI'.
There are 2 rows in 2 pages for object "updsc1.DIM_SOLUADILI".
DBCC results for 'di_writer.DIM_DATE_2016'.
There are 1461 rows in 20 pages for object "di_writer.DIM_DATE_2016".
DBCC results for 'upddel.DIM_SOLUADILI'.
There are 0 rows in 0 pages for object "upddel.DIM_SOLUADILI".
DBCC results for 'di_writer.DIM_BANKAREIKN'.
There are 13545 rows in 426 pages for object "di_writer.DIM_BANKAREIKN".
DBCC results for 'di_writer.FACT_MULTICURRENCY'.
There are 3664684 rows in 29674 pages for object "di_writer.FACT_MULTICURRENCY".
DBCC results for 'di_writer.FACT_PARTNER_MERC'.
There are 30783 rows in 290 pages for object "di_writer.FACT_PARTNER_MERC".
DBCC results for 'sysdiagrams'.
There are 0 rows in 0 pages for object "sysdiagrams".
DBCC results for 'updexp.DIM_SOLUADILI'.
There are 0 rows in 0 pages for object "updexp.DIM_SOLUADILI".
DBCC results for 'di_writer.DIM_MCC_YFIRFLOKKUR'.
There are 15 rows in 1 pages for object "di_writer.DIM_MCC_YFIRFLOKKUR".
DBCC results for 'di_writer.DIM_ISSUER_YFL'.
There are 4 rows in 1 pages for object "di_writer.DIM_ISSUER_YFL".
DBCC results for 'updsc1.DIM_SAMNINGUR'.
There are 8841 rows in 396 pages for object "updsc1.DIM_SAMNINGUR".
DBCC results for 'upddel.DIM_SAMNINGUR'.
There are 0 rows in 0 pages for object "upddel.DIM_SAMNINGUR".
DBCC results for 'di_writer.DIM_NOTIFICATION'.
There are 7 rows in 1 pages for object "di_writer.DIM_NOTIFICATION".
DBCC results for 'updexp.DIM_SAMNINGUR'.
There are 0 rows in 0 pages for object "updexp.DIM_SAMNINGUR".
DBCC results for 'di_writer.DIM_STATUS'.
There are 18 rows in 1 pages for object "di_writer.DIM_STATUS".
DBCC results for 'di_writer.FACT_ER_UPPGJOR_AGENT'.
There are 9398876 rows in 205980 pages for object "di_writer.FACT_ER_UPPGJOR_AGENT".
DBCC results for 'di_writer.DIM_REGION'.
There are 12 rows in 2 pages for object "di_writer.DIM_REGION".
DBCC results for 'di_writer.DIM_AHAETTUFLOKKUR'.
There are 4 rows in 1 pages for object "di_writer.DIM_AHAETTUFLOKKUR".
DBCC results for 'di_writer.FACT_REGION_COUNTRY'.
There are 592 rows in 6 pages for object "di_writer.FACT_REGION_COUNTRY".
DBCC results for 'di_writer.FACT_GREIDSLUSKRA'.
There are 2155955 rows in 34998 pages for object "di_writer.FACT_GREIDSLUSKRA".
DBCC results for 'di_writer.DIM_AHAETTULIDUR'.
There are 626 rows in 4 pages for object "di_writer.DIM_AHAETTULIDUR".
DBCC results for 'di_writer.DIM_SOLUTEGUND'.
There are 29 rows in 1 pages for object "di_writer.DIM_SOLUTEGUND".
DBCC results for 'di_writer.DIM_FAERSLUFLOKKUR'.
There are 4 rows in 1 pages for object "di_writer.DIM_FAERSLUFLOKKUR".
DBCC results for 'di_writer.DIM_COMMISSION'.
There are 11160 rows in 224 pages for object "di_writer.DIM_COMMISSION".
DBCC results for 'di_writer.Audit_Job'.
There are 24653 rows in 252 pages for object "di_writer.Audit_Job".
DBCC results for 'di_writer.DIM_FAERSLULIDUR'.
There are 1532 rows in 17 pages for object "di_writer.DIM_FAERSLULIDUR".
DBCC results for 'di_writer.DIM_ATRIDI'.
There are 389 rows in 2 pages for object "di_writer.DIM_ATRIDI".
DBCC results for 'di_writer.DIM_SOLUADILI_NAFN'.
There are 2114228 rows in 10364 pages for object "di_writer.DIM_SOLUADILI_NAFN".
DBCC results for 'di_writer.DIM_GJALDMIDILL'.
There are 204 rows in 3 pages for object "di_writer.DIM_GJALDMIDILL".
DBCC results for 'di_writer.DIM_STARFSMADUR'.
There are 126 rows in 1 pages for object "di_writer.DIM_STARFSMADUR".
DBCC results for 'di_writer.DIM_DE_KORT_OLD'.
There are 512132 rows in 2600 pages for object "di_writer.DIM_DE_KORT_OLD".
DBCC results for 'di_writer.DIM_TAFLA'.
There are 34 rows in 1 pages for object "di_writer.DIM_TAFLA".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'di_writer.FACT_DADE_KORTAFAERSLA'.
There are 188852846 rows in 4020175 pages for object "di_writer.FACT_DADE_KORTAFAERSLA".
DBCC results for 'di_writer.FACT_ER_BREYTING'.
There are 4130491 rows in 69447 pages for object "di_writer.FACT_ER_BREYTING".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'di_writer.DIM_DE_KORT'.
There are 54042 rows in 302 pages for object "di_writer.DIM_DE_KORT".
DBCC results for 'di_writer.DIM_REASONCODE'.
There are 114 rows in 2 pages for object "di_writer.DIM_REASONCODE".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'export.Partner'.
There are 1 rows in 1 pages for object "export.Partner".
DBCC results for 'export.Merchant'.
There are 1 rows in 1 pages for object "export.Merchant".
DBCC results for 'di_writer.FACT_GENGI'.
There are 531950 rows in 4131 pages for object "di_writer.FACT_GENGI".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'VoruhusGagna'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
*/
Worth to mention is we have tried to restore the same backups onto a different instance with the same result.
Microsoft SQL Server 2014 (SP2-CU1) (KB3178925) - 12.0.5511.0 (X64) Aug 19 2016 14:32:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
The VLF count is now 18 but was a spanking 1440 ! The backups mentioned were taken after fixing the log file VLF situation.
Any good ideas ? 🙂
Thanks in advance,
Gudjon
December 1, 2016 at 4:21 am
December 1, 2016 at 5:07 am
This was removed by the editor as SPAM
December 1, 2016 at 5:44 am
Thank you for your response 🙂
HasIncompleteMetaData is 0
December 1, 2016 at 6:08 am
Try the following on the production DB out of hours:
USE [VoruhusGagna];
GO
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS;
GO
December 1, 2016 at 6:55 am
Can you outline the steps you took for "we have already restored the appropriate thumbprint"?
December 1, 2016 at 7:36 am
USE [master] ;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '********' ;
GO
CREATE CERTIFICATE [VoruhusGagnaCert_2011_1]
FROM FILE = N'<path>\VoruhusGagnaCert_2011_1.cer'
WITH PRIVATE KEY (
FILE = N'<path>\PrivateKey_VoruhusGagnaCert_2011_1.key'
, DECRYPTION BY PASSWORD = '****************' ;
)
GO
December 2, 2016 at 5:55 am
Your original database is configured with TDE. I am willing to bet encryption in the database is preventing the restoration from completing.
What steps have you taken to restore the encryption key from the source instance to the target instance?
December 2, 2016 at 5:56 am
kevaburg (12/2/2016)
Your original database is configured with TDE. I am willing to bet encryption in the database is preventing the restoration from completing.What steps have you taken to restore the encryption key from the source instance to the target instance?
Sorry, I should have read the post above.....
December 3, 2016 at 3:55 am
I did run the following
USE [VoruhusGagna];
GO
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS;
GO
It resulted in
Command(s) completed successfully.
From the log
Message
DBCC CHECKDB (VoruhusGagna) WITH all_errormsgs, no_infomsgs, data_purity executed by <user> found 0 errors and repaired 0 errors. Elapsed time: 8 hours 29 minutes 42 seconds. Internal database snapshot has split point LSN = 0005469a:0034a457:0001 and first LSN = 0005469a:0034a456:0001.
The database seems to be in a healthy state at it's original location :unsure:
December 5, 2016 at 5:43 am
To eliminate the TDE is causing problems we have removed it
USE [master] ;
GO
-- remove tde
ALTER DATABASE [VoruhusGagna] SET ENCRYPTION OFF ;
GO
-- monitor the progress
SELECT [percent_complete], *
FROM [sys].[dm_database_encryption_keys] ;
USE [VoruhusGagna]
GO
DROP DATABASE ENCRYPTION KEY ;
GO
-- verify encryption removed
SELECT [name], is_encrypted, *
FROM sys.databases
WHERE [name] = 'VoruhusGagna' ;
GO
We are baking a brand new full backup to try out on the 2016 server...
December 5, 2016 at 6:48 am
Guðjón Kr. Sigurðsson (12/5/2016)
To eliminate the TDE is causing problems we have removed it
USE [master] ;
GO
-- remove tde
ALTER DATABASE [VoruhusGagna] SET ENCRYPTION OFF ;
GO
-- monitor the progress
SELECT [percent_complete], *
FROM [sys].[dm_database_encryption_keys] ;
USE [VoruhusGagna]
GO
DROP DATABASE ENCRYPTION KEY ;
GO
-- verify encryption removed
SELECT [name], is_encrypted, *
FROM sys.databases
WHERE [name] = 'VoruhusGagna' ;
GO
We are baking a brand new full backup to try out on the 2016 server...
I am one person interested in seeing how that works out.
Did you try detaching and attaching the database in the new instance? Just out of curiosity....
December 6, 2016 at 3:33 am
Turns out removing the TDE before a new backup was the solution. 🙂
We had not tried the detach/attach method.
December 6, 2016 at 9:13 am
Guðjón Kr. Sigurðsson (12/6/2016)
Turns out removing the TDE before a new backup was the solution. 🙂We had not tried the detach/attach method.
There shouldnt be any reason why you cannot restore a backup of your TDE protected database to another server.
Questions:
do you run regular checkdb on the source database, does it display any errors?
does the backup throw up any issues on the source?
do you verify the backup file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:31 am
That's what we thought.
We did restore successfully number of other smaller databases that were also encrypted whith TDE.
This one particular was giving us problems.
We did verify the backups and the integrity of the source database.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply