{"id":2414,"date":"2014-05-21T11:00:23","date_gmt":"2014-05-21T15:00:23","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=2414"},"modified":"2014-11-13T13:38:32","modified_gmt":"2014-11-13T18:38:32","slug":"dbcc-fileheader","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/","title":{"rendered":"DBCC FILEHEADER: Reading the File Header Page"},"content":{"rendered":"<div>\n<h3>Introduction<\/h3>\n<p>\nEvery database file contains a single page that contains information about the file itself. It is called the file header page. The file header page is always the first page of any file, page 0.\n<\/p>\n<h3>Examining the File Header Page<\/h3>\n<p>\nLike any other page, using <a href=\"http:\/\/sqlity.net\/en\/2033\/the-page\/\"><span class=\"tt\">DBCC PAGE<\/span> with type 3<\/a> (after turning trace flag 3604 on for the connection) is a good way to dive into the page's content:\n<\/p>\n<div>\n[sql]\nDBCC TRACEON(3604);<br \/>\nDBCC PAGE(0,1,0,3);<br \/>\n[\/sql]\n<\/div>\n<p>\nBelow is the beginning of the page header for this page.\n<\/p>\n<p>\n<a href=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_PAGE_for_File_Header_Page.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_PAGE_for_File_Header_Page.jpg\" alt=\"DBCC PAGE for a File Header Page.\" title=\"DBCC PAGE for a File Header Page.\" width=\"768\" height=\"479\" class=\"aligncenter size-full wp-image-2416\" srcset=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_PAGE_for_File_Header_Page.jpg 768w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_PAGE_for_File_Header_Page-300x187.jpg 300w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_PAGE_for_File_Header_Page-150x93.jpg 150w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n<\/p>\n<p>\nAs you can see, the page type for the file header page is 15. If you run the statement yourself, you will notice that the output of <span class=\"tt\">DBCC PAGE<\/span> for this page type is not as clean as we would like.\n<\/p>\n<h3>Introducing: DBCC FILEHEADER<\/h3>\n<p>\nInstead of trying to make sense of the output, there is an easier way, the also undocumented <span class=\"tt\">DBCC FILEHEADER<\/span> command:\n<\/p>\n<div>\n[sql]\nDBCC FILEHEADER(0,1);<br \/>\n[\/sql]\n<\/div>\n<p>\n<span class=\"tt\">DBCC FILEHEADER<\/span> takes two parameters. The first is the database id or the database name. If you pass in <span class=\"tt\">0<\/span> as in the example above, the current database is used. The second parameter is the file id, the same value you would use as second parameter for the <span class=\"tt\">DBCC PAGE<\/span> command. <span class=\"tt\">DBCC FILEHEADER<\/span> can be used for log files too. As log files are not organized in pages, <span class=\"tt\">DBCC PAGE<\/span> fails if you attempt to access a log file with it.\n<\/p>\n<p>\n<span class=\"tt\">DBCC FILEHEADER<\/span> produces a single result set as output:\n<\/p>\n<p>\n<a href=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg\" alt=\"DBCC FILEHEADER in Action.\" title=\"DBCC FILEHEADER in Action.\" width=\"768\" height=\"479\" class=\"aligncenter size-full wp-image-2415\" srcset=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg 768w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action-300x187.jpg 300w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action-150x93.jpg 150w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n<\/p>\n<p>\nMost of the values deal with backup management but for example, the file name is in there too. Below is the complete list of values returned.\n<\/p>\n<table>\n<tbody>\n<tr>\n<td>RecoveryUnitId<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>FileId<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>LogicalName<\/td>\n<td>Image \u00a9sqlity.net 2014<\/td>\n<\/tr>\n<tr>\n<td>BindingId<\/td>\n<td>60371E59-22B9-412F-835C-8B88B1173F07<\/td>\n<\/tr>\n<tr>\n<td>FileGroup<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>Size<\/td>\n<td>7688<\/td>\n<\/tr>\n<tr>\n<td>MaxSize<\/td>\n<td>-1<\/td>\n<\/tr>\n<tr>\n<td>MinSize<\/td>\n<td>392<\/td>\n<\/tr>\n<tr>\n<td>UserShrinkSize<\/td>\n<td>-1<\/td>\n<\/tr>\n<tr>\n<td>Growth<\/td>\n<td>128<\/td>\n<\/tr>\n<tr>\n<td>BackupLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>RedoStartLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>FirstLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>MaxLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>FirstUpdateLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>CreateLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>SectorSize<\/td>\n<td>512<\/td>\n<\/tr>\n<tr>\n<td>ActualSectorSize<\/td>\n<td>512<\/td>\n<\/tr>\n<tr>\n<td>RecoveryForkGUID<\/td>\n<td>00000000-0000-0000-0000-000000000000<\/td>\n<\/tr>\n<tr>\n<td>RecoveryForkLSN<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>DifferentialBaseLsn<\/td>\n<td>285000000204700037<\/td>\n<\/tr>\n<tr>\n<td>DifferentialBaseGuid<\/td>\n<td>9C180429-584D-4F07-B5C4-9FB47480147D<\/td>\n<\/tr>\n<tr>\n<td>Status<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td>RestoreStatus<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>ReadOnlyLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>ReadWriteLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>MaxLsnBranchId<\/td>\n<td>00000000-0000-0000-0000-000000000000<\/td>\n<\/tr>\n<tr>\n<td>RedoTargetPointLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>RedoTargetPointGuid<\/td>\n<td>00000000-0000-0000-0000-000000000000<\/td>\n<\/tr>\n<tr>\n<td>RestoreDiffBaseLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>RestoreDiffBaseGuid<\/td>\n<td>00000000-0000-0000-0000-000000000000<\/td>\n<\/tr>\n<tr>\n<td>RestorePathOriginLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>RestorePathOriginGuid<\/td>\n<td>00000000-0000-0000-0000-000000000000<\/td>\n<\/tr>\n<tr>\n<td>OldestRestoredLsn<\/td>\n<td>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\nThe one thing you can see immediately is that I have not been very diligent backing up this database\u2026\n<\/p>\n<h3>Backups, Anyone?<\/h3>\n<p>\nWhile we are talking about backups, there is one special behavior with file header pages that should not go unmentioned: If the file header page should ever become corrupt, SQL Server will refuse to even touch that file. While for other pages, you might be able to read \"around\" the problem by mounting the database in emergency mode and\/or executing <span class=\"tt\">DBCC CHECKDB<\/span> with one of the repair options, <a href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-21-file-header-pages-and-file-header-corruption\/\" target=\"sqlskills\">if the file header page becomes corrupt you are out of luck<\/a>. The only way to recover from this situation is to restore a good and recent backup.\n<\/p>\n<h3>Summary<\/h3>\n<p>\nEvery database file includes a file header. For data files, it is stored in a special page, the file header page. While you could use <span class=\"tt\">DBCC PAGE<\/span> for file header pages, the <span class=\"tt\">DBCC FILEHEADER<\/span> command offers a more readable output and has the added benefit to work with log files too.\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Every SQL Server database file has a dedicated file header page. Read on to discover how to use DBCC FILEHEADER to explore the header of your database files and learn about the one property of file header pages that might just affect your backup and restore strategy.<\/p>\n<p> <a href=\"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":2415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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}},"categories":[5,27,14,105],"tags":[70,187,111,186,107,114,15],"class_list":["post-2414","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-series","category-sql-server-internals","category-storage-wednesday","tag-backup-2","tag-dbcc-fileheader","tag-dbcc-page","tag-file-header","tag-page","tag-page-header","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DBCC FILEHEADER: Reading the File Header Page - sqlity.net<\/title>\n<meta name=\"description\" content=\"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.\" \/>\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\/2414\/dbcc-fileheader\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBCC FILEHEADER: Reading the File Header Page - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/\" \/>\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-21T15:00:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:38:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"DBCC FILEHEADER: Reading the File Header Page\",\"datePublished\":\"2014-05-21T15:00:23+00:00\",\"dateModified\":\"2014-11-13T18:38:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/\"},\"wordCount\":544,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/DBCC_FILEHEADER_in_action.jpg\",\"keywords\":[\"backup\",\"DBCC FILEHEADER\",\"DBCC PAGE\",\"File Header\",\"page\",\"Page Header\",\"SQL Server\"],\"articleSection\":[\"General\",\"Series\",\"SQL Server Internals\",\"Storage Wednesday\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/\",\"name\":\"DBCC FILEHEADER: Reading the File Header Page - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/DBCC_FILEHEADER_in_action.jpg\",\"datePublished\":\"2014-05-21T15:00:23+00:00\",\"dateModified\":\"2014-11-13T18:38:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/DBCC_FILEHEADER_in_action.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/DBCC_FILEHEADER_in_action.jpg\",\"width\":768,\"height\":479,\"caption\":\"DBCC FILEHEADER in Action.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2414\\\/dbcc-fileheader\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBCC FILEHEADER: Reading the File Header 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":"DBCC FILEHEADER: Reading the File Header Page - sqlity.net","description":"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.","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\/2414\/dbcc-fileheader\/","og_locale":"en_US","og_type":"article","og_title":"DBCC FILEHEADER: Reading the File Header Page - sqlity.net","og_description":"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.","og_url":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2014-05-21T15:00:23+00:00","article_modified_time":"2014-11-13T18:38:32+00:00","og_image":[{"width":768,"height":479,"url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"DBCC FILEHEADER: Reading the File Header Page","datePublished":"2014-05-21T15:00:23+00:00","dateModified":"2014-11-13T18:38:32+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/"},"wordCount":544,"commentCount":1,"image":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg","keywords":["backup","DBCC FILEHEADER","DBCC PAGE","File Header","page","Page Header","SQL Server"],"articleSection":["General","Series","SQL Server Internals","Storage Wednesday"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/","url":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/","name":"DBCC FILEHEADER: Reading the File Header Page - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg","datePublished":"2014-05-21T15:00:23+00:00","dateModified":"2014-11-13T18:38:32+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Every SQL Server database file has a dedicated file header page. Read on and discover how to use DBCC FILEHEADER to explore the header of your db files.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#primaryimage","url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg","contentUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg","width":768,"height":479,"caption":"DBCC FILEHEADER in Action."},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/2414\/dbcc-fileheader\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"DBCC FILEHEADER: Reading the File Header 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_featured_media_url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/05\/DBCC_FILEHEADER_in_action.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-CW","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2414","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=2414"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2414\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media\/2415"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=2414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=2414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=2414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}