{"id":2422,"date":"2014-05-28T11:00:59","date_gmt":"2014-05-28T15:00:59","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=2422"},"modified":"2014-11-13T13:38:00","modified_gmt":"2014-11-13T18:38:00","slug":"boot-page","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/2422\/boot-page\/","title":{"rendered":"The Secret of the Database Boot Page"},"content":{"rendered":"
\n

Introduction<\/h3>\n

\nThere is one special data page that exists only once per database. It is the database boot page. The database boot page is always stored in page 9 of file 1, the first file in the primary file group.\n<\/p>\n

The Database Boot Page Examined<\/h3>\n

\nAs with many other internal SQL Server structures, the database boot page is not documented. In most cases, you probably will not even need to ever look at it. But, if the need arises it is always good to be prepared.\n<\/p>\n

\nThe database boot page contains a broad variety of data about the database itself. Here you can find the internal database version, the compatibility level, the database name and the date of the last log backup. But, you can also find more obscure values, like the one that is just called \"safety\". It is set to 0<\/span> in my database. I hope that is not a bad sign...\n<\/p>\n

\nTo look into this page, we can use the same DBCC PAGE<\/span> command we have used with the other page types. I am not aware of any special command like DBCC FILEHEADER<\/span><\/a> that would produce an easier to read output of the database boot page, but new undocumented DBCC Commands still keep appearing every once in a while.\n<\/p>\n

\nSo let us actually take a look at this page:\n<\/p>\n

\n[sql]\nDBCC TRACEON(3604);
\nDBCC PAGE(0,1,9,3);
\n[\/sql]\n<\/div>\n

\nAs always, DBCC PAGE<\/span> requires trace flag 3604<\/a> to be turned on for the connection.\n<\/p>\n

\nThe image below shows part of the output:\n<\/p>\n

\n\"The<\/a>\n<\/p>\n

\nYou can see that the page type of the database boot page is 13. The full output is shown below:\n<\/p>\n

\n[sourcecode]\nDBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/p>\n

PAGE: (1:9)<\/p>\n

BUFFER:<\/p>\n

BUF @0x00000000041F1740<\/p>\n

bpage = 0x00000001F149A000 bhash = 0x0000000000000000 bpageno = (1:9)
\nbdbid = 16 breferences = 0 bcputicks = 0
\nbsampleCount = 0 bUse1 = 50077 bstat = 0x9
\nblog = 0x15ab215a bnext = 0x0000000000000000 <\/p>\n

PAGE HEADER:<\/p>\n

Page @0x00000001F149A000<\/p>\n

m_pageId = (1:9) m_headerVersion = 1 m_type = 13
\nm_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x200
\nm_objId (AllocUnitId.idObj) = 99 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 6488064
\nMetadata: PartitionId = 0 Metadata: IndexId = 0 Metadata: ObjectId = 99
\nm_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0
\nm_slotCnt = 1 m_freeCnt = 6590 m_freeData = 1600
\nm_reservedCnt = 0 m_lsn = (286:240:2) m_xactReserved = 0
\nm_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 1246961098
\nDB Frag ID = 1 <\/p>\n

Allocation Status<\/p>\n

GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
\nPFS (1:1) = 0x64 MIXED_EXT ALLOCATED 100_PCT_FULL DIFF (1:6) = CHANGED
\nML (1:7) = NOT MIN_LOGGED <\/p>\n

Slot 0, Offset 0x60, Length 1504, DumpStyle BYTE<\/p>\n

Record Type = PRIMARY_RECORD Record Attributes = Record Size = 1504<\/p>\n

Memory Dump @0x000000006F8BA060<\/p>\n

0000000000000000: 0000e005 c202c202 00000000 00000000 00000000 ..\u00e0.\u00c2.\u00c2.............
\n0000000000000014: 9847bc00 1ca30000 00000000 00000000 00000100 .G\u00bc..\u00a3..............
\n0000000000000028: 755c907b 88ee8d00 b7a20000 49006d00 61006700 u\\.{.\u00ee..\u2022\u00a2..I.m.a.g.
\n000000000000003C: 65002000 a9007300 71006c00 69007400 79002e00 e. .\u00a9.s.q.l.i.t.y...
\n0000000000000050: 6e006500 74002000 32003000 31003400 20202020 n.e.t. .2.0.1.4.
\n0000000000000064: 20202020 20202020 20202020 20202020 20202020
\n0000000000000078: 20202020 20202020 20202020 20202020 20202020
\n000000000000008C: 20202020 20202020 20202020 20202020 20202020
\n00000000000000A0: 20202020 20202020 20202020 20202020 20202020
\n00000000000000B4: 20202020 20202020 20202020 20202020 20202020
\n00000000000000C8: 20202020 20202020 20202020 20202020 20202020
\n00000000000000DC: 20202020 20202020 20202020 20202020 20202020
\n00000000000000F0: 20202020 20202020 20202020 20202020 20202020
\n0000000000000104: 20202020 20202020 20202020 20202020 20202020
\n0000000000000118: 20202020 20202020 20202020 20202020 20202020
\n000000000000012C: 20202020 20202020 2c000000 10006e00 d0070000 ,.....n.\u00d0...
\n0000000000000140: 00000000 b3000000 24020000 7a000000 1d010000 ....\u00b3...$...z.......
\n0000000000000154: ff070000 25000000 1e010000 ed000000 03000200 \u00ff...%.......\u00ed.......
\n0000000000000168: 00000000 00000000 00000000 1e010000 ed000000 ................\u00ed...
\n000000000000017C: 03000000 39aa0000 00000000 08d00034 00000000 ....9\u00aa.......\u00d0.4....
\n0000000000000190: 00000061 00000000 8fe3a2de 3ec3a94a 81a7dc8a ...a.....\u00e3\u00a2\u00de>\u00c3\u00a9J.\u00a7\u00dc\u008a
\n00000000000001A4: f11beec8 000a5404 00000000 00000000 00000000 \u00f1.\u00ee\u00c8..T.............
\n00000000000001B8: 00000000 00000000 00000000 00000000 8fe3a2de .................\u00e3\u00a2\u00de
\n00000000000001CC: 3ec3a94a 81a7dc8a f11beec8 00000000 00000000 >\u00c3\u00a9J.\u00a7\u00dc\u008a\u00f1.\u00ee\u00c8........
\n00000000000001E0: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000001F4: 2904189c 4d58074f b5c49fb4 7480147d 14000000 )..\u009cMX.O\u00b5\u00c4\u009f\u00b4t..}....
\n0000000000000208: 01006302 00000000 00000000 00000000 00000000 ..c.................
\n000000000000021C: 00000000 00000400 00000000 00000000 00000000 ....................
\n0000000000000230: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000244: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000258: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000026C: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000280: b3000000 24020000 7a000000 00000000 00000000 \u00b3...$...z...........
\n0000000000000294: 00000000 00000000 00000000 00000000 88ee8d00 .................\u00ee..
\n00000000000002A8: b7a20000 b80b000b 00000000 12c47174 bcd2124d \u2022\u00a2..\u00b8........\u00c4qt\u00bc\u00d2.M
\n00000000000002BC: 9ae2e518 f49bdba2 01000000 00000000 00000000 \u009a\u00e2\u00e5.\u00f4\u009b\u00db\u00a2............
\n00000000000002D0: 00000000 00000000 00000000 00000000 fb000000 ................\u00fb...
\n00000000000002E4: 00010000 00000000 00000000 00000000 00000000 ....................
\n00000000000002F8: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000030C: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000320: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000334: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000348: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000035C: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000370: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000384: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000398: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000003AC: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000003C0: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000003D4: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000003E8: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000003FC: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000410: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000424: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000438: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000044C: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000460: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000474: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000488: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000049C: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000004B0: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000004C4: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000004D8: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000004EC: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000500: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000514: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000528: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000053C: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000550: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000564: 00000000 00000000 00000000 00000000 00000000 ....................
\n0000000000000578: 00000000 00000000 00000000 00000000 00000000 ....................
\n000000000000058C: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000005A0: 00000000 00000000 00000000 12000000 51000000 ................Q...
\n00000000000005B4: 43000000 00000000 00000000 00000000 01000000 C...................
\n00000000000005C8: 00000000 00000000 00000000 00000000 00000000 ....................
\n00000000000005DC: 00000000 .... <\/p>\n

DBINFO @0x000000006F8BA060<\/p>\n

dbi_version = 706 dbi_createVersion = 706 dbi_SEVersion = 0
\ndbi_dvSplitPoint = 0:0:0 (0x00000000:00000000:0000)
\ndbi_dbbackupLSN = 179:548:122 (0x000000b3:00000224:007a)
\ndbi_LastLogBackupTime = 2014-04-29 11:25:30.320
\ndbi_nextseqnum = 1900-01-01 00:00:00.000 dbi_status = 0x00010000
\ndbi_crdate = 2014-01-18 08:36:45.467dbi_dbname = Image \u00a9sqlity.net 2014 dbi_dbid = 16
\ndbi_cmptlevel = 110 dbi_masterfixups = 0 dbi_maxDbTimestamp = 2000
\ndbi_dbbackupLSN = 179:548:122 (0x000000b3:00000224:007a) dbi_RebuildLogs = 0
\ndbi_differentialBaseLSN = 285:2047:37 (0x0000011d:000007ff:0025) dbi_RestoreFlags = 0x0000
\ndbi_checkptLSN = 286:237:3 (0x0000011e:000000ed:0003) dbi_dbccFlags = 2
\ndbi_COWLastLSN = 0:0:0 (0x00000000:00000000:0000)
\ndbi_DirtyPageLSN = 286:237:3 (0x0000011e:000000ed:0003) dbi_RecoveryFlags = 0x00000000
\ndbi_lastxact = 0xaa39 dbi_collation = 872468488 dbi_relstat = 0x61000000
\ndbi_familyGUID = dea2e38f-c33e-4aa9-81a7-dc8af11beec8 dbi_maxLogSpaceUsed = 72616448<\/p>\n

dbi_recoveryForkNameStack<\/p>\n

entry 0<\/p>\n

hex (dec) = 0x00000000:00000000:0000 (0:0:0)
\nm_guid = dea2e38f-c33e-4aa9-81a7-dc8af11beec8 <\/p>\n

entry 1<\/p>\n

hex (dec) = 0x00000000:00000000:0000 (0:0:0)
\nm_guid = 00000000-0000-0000-0000-000000000000
\ndbi_differentialBaseGuid = 9c180429-584d-4f07-b5c4-9fb47480147d dbi_firstSysIndexes = 0001:00000014
\ndbi_oldestBackupXactLSN = 0:0:0 (0x00000000:00000000:0000)
\ndbi_versionChangeLSN = 0:0:0 (0x00000000:00000000:0000) dbi_mdUpgStat = 0x0004
\ndbi_category = 0x0000000000000000 dbi_safetySequence = 0
\ndbi_dbMirrorId = 00000000-0000-0000-0000-000000000000
\ndbi_pageUndoLsn = 0:0:0 (0x00000000:00000000:0000) dbi_pageUndoState = 0
\ndbi_disabledSequence = 0 dbi_dbmRedoLsn = 0:0:0 (0x00000000:00000000:0000)
\ndbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000) dbi_CloneCpuCount = 0
\ndbi_CloneMemorySize = 0 dbi_updSysCatalog = 1900-01-01 00:00:00.000
\ndbi_LogBackupChainOrigin = 179:548:122 (0x000000b3:00000224:007a)
\ndbi_dbccLastKnownGood = 1900-01-01 00:00:00.000 dbi_roleSequence = 0
\ndbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000) dbi_localState = 0
\ndbi_safety = 0 dbi_modDate = 2014-01-18 08:36:45.467
\ndbi_verRDB = 184552376 dbi_lazyCommitOption = 0
\ndbi_svcBrokerGUID = 7471c412-d2bc-4d12-9ae2-e518f49bdba2 dbi_svcBrokerOptions = 0x00000001
\ndbi_dbmLogZeroOutstanding = 0 dbi_dbmLastGoodRoleSequence = 0 dbi_dbmRedoQueue = 0
\ndbi_dbmRedoQueueType = 0 dbi_rmidRegistryValueDeleted = 0 dbi_dbmConnectionTimeout = 0
\ndbi_fragmentId = 0 dbi_AuIdNext = 1099511628027
\ndbi_MinSkipLsn = 0:0:0 (0x00000000:00000000:0000) dbi_commitTsOfcheckptLSN = 0
\ndbi_dbEmptyVersionState = 0 dbi_CurrentGeneration = 0
\ndbi_EncryptionHistory<\/p>\n

Scan 0<\/p>\n

hex (dec) = 0x00000000:00000000:0000 (0:0:0)
\nEncryptionScanInfo:ScanId = 0 <\/p>\n

Scan 1<\/p>\n

hex (dec) = 0x00000000:00000000:0000 (0:0:0)
\nEncryptionScanInfo:ScanId = 0 <\/p>\n

Scan 2<\/p>\n

hex (dec) = 0x00000000:00000000:0000 (0:0:0)
\nEncryptionScanInfo:ScanId = 0
\ndbi_latestVersioningUpgradeLSN = 18:81:67 (0x00000012:00000051:0043) dbi_splitAGE = 0
\ndbi_PendingRestoreOutcomesId = 00000000-0000-0000-0000-000000000000 dbi_ContianmentState = 1<\/p>\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
\n[\/sourcecode]\n<\/p><\/div>\n

Summary<\/h3>\n

\nEvery database contains a single database boot page to store database settings and configuration values. You can always find this special page in page 9 of the first data file.\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.<\/P [more…]<\/a><\/p>\n","protected":false},"author":3,"featured_media":2423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5,27,14,105],"tags":[189,111,106,15],"class_list":["post-2422","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-series","category-sql-server-internals","category-storage-wednesday","tag-boot-page","tag-dbcc-page","tag-internals","tag-sql-server"],"acf":[],"yoast_head":"\nThe Secret of the Database Boot Page - sqlity.net<\/title>\n<meta name=\"description\" content=\"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/2422\/boot-page\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Secret of the Database Boot Page - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/2422\/boot-page\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-28T15:00:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:38:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"479\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"The Secret of the Database Boot Page\",\"datePublished\":\"2014-05-28T15:00:59+00:00\",\"dateModified\":\"2014-11-13T18:38:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/\"},\"wordCount\":262,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/The_Boot_Page.jpg\",\"keywords\":[\"boot page\",\"DBCC PAGE\",\"internals\",\"SQL Server\"],\"articleSection\":[\"General\",\"Series\",\"SQL Server Internals\",\"Storage Wednesday\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/\",\"name\":\"The Secret of the Database Boot Page - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/The_Boot_Page.jpg\",\"datePublished\":\"2014-05-28T15:00:59+00:00\",\"dateModified\":\"2014-11-13T18:38:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/The_Boot_Page.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/The_Boot_Page.jpg\",\"width\":768,\"height\":479,\"caption\":\"The database boot page.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2422\\\/boot-page\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Secret of the Database Boot Page\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Secret of the Database Boot Page - sqlity.net","description":"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlity.net\/en\/2422\/boot-page\/","og_locale":"en_US","og_type":"article","og_title":"The Secret of the Database Boot Page - sqlity.net","og_description":"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.","og_url":"https:\/\/sqlity.net\/en\/2422\/boot-page\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2014-05-28T15:00:59+00:00","article_modified_time":"2014-11-13T18:38:00+00:00","og_image":[{"width":768,"height":479,"url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","type":"image\/jpeg"}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"The Secret of the Database Boot Page","datePublished":"2014-05-28T15:00:59+00:00","dateModified":"2014-11-13T18:38:00+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/"},"wordCount":262,"commentCount":0,"image":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","keywords":["boot page","DBCC PAGE","internals","SQL Server"],"articleSection":["General","Series","SQL Server Internals","Storage Wednesday"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/2422\/boot-page\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/","url":"https:\/\/sqlity.net\/en\/2422\/boot-page\/","name":"The Secret of the Database Boot Page - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","datePublished":"2014-05-28T15:00:59+00:00","dateModified":"2014-11-13T18:38:00+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/2422\/boot-page\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#primaryimage","url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","contentUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","width":768,"height":479,"caption":"The database boot page."},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/2422\/boot-page\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"The Secret of the Database Boot Page"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-D4","jetpack-related-posts":[],"jetpack_featured_media_url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/The_Boot_Page.jpg","_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=2422"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2422\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media\/2423"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=2422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=2422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=2422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}