Msg 605, Level 21, State 3, Line 1
Attempt to fetch logical page (1:105756) in database 21 failed. It belongs to allocation unit 72057594900840448 not to 72057594899529728.
Completion time: 2025-07-06T12:14:08.6294025+02:00<\/pre>\n\n\n\n
Pokusy odpojit datab\u00e1zi (Dettach) kon\u010d\u00ed chybou.<\/p>\n\n\n\n Obvykle pom\u016f\u017ee odpojit db do re\u017eimu Offline (Take Offline). Pak u\u017e odpojen\u00ed (Dettach) projde.<\/p>\n\n\n\n Nyn\u00ed p\u0159ejmenujte soubor s transak\u010dn\u00edmi logy (*.ldf), aby ho SQL server „nevid\u011bl“.<\/p>\n\n\n\n Nyn\u00ed je t\u0159eba p\u0159ipojit datab\u00e1zi a SQL serveru \u0159\u00edci, \u017ee m\u00e1 opravit (tedy znovuvytvo\u0159it) transak\u010dn\u00ed log.<\/p>\n\n\n\n N\u00e1sledn\u011b m\u016f\u017eete opravit poru\u0161enou db.<\/p>\n\n\n\n V\u00fdstup m\u016f\u017ee vypadat n\u011bjak takto:<\/p>\n\n\n\n Nyn\u00ed m\u016f\u017eete vr\u00e1tit datab\u00e1zi do provozu.<\/p>\n\n\n\n Podrobn\u011bj\u0161\u00ed popis pou\u017eit\u00ed DBCC najdete v tomto \u010dl\u00e1nku.<\/p>\n","protected":false},"excerpt":{"rendered":" Narazil jsem na probl\u00e9m, kdy po nekorektn\u00edm vypnut\u00ed SQL serveru do\u0161lo k poru\u0161en\u00ed datab\u00e1ze. Krom\u011b toho byl po\u0161kozen transak\u010dn\u00ed log (*.ldf) a datab\u00e1ze vypadala naprosto nepou\u017eiteln\u011b. P\u0159\u00edznaky vypadaj\u00ed n\u00e1sledovn\u011b: select * from [Databaze].Tabulka order by CreateDateMsg 605, Level 21, State 3, Line 1Attempt to fetch logical page (1:105756) in database 21 failed. It belongs to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[5],"tags":[],"class_list":["post-748","post","type-post","status-publish","format-standard","hentry","category-technologie","entry"],"yoast_head":"\n![\"\"](\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2025\/07\/image-1.png\")
<\/figure>\n\n\n\nCREATE DATABASE [Databaze]
ON (FILENAME = 'E:\\MSSQL\\DATA\\Restore\\Databaze.mdf')
FOR ATTACH_REBUILD_LOG
<\/pre>\n\n\n\nalter database Databaze set emergency
go
alter database Databaze set single_user
go
use master
go
DBCC CHECKDB ('Databaze', REPAIR_ALLOW_DATA_LOSS)<\/pre>\n\n\n\nDBCC results for 'Databaze'.
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.
Repair: The extent (1:106056) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown).
Repair: The extent (1:105840) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901495808 (type Unknown).
Repair: The extent (1:106136) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901495808 (type Unknown).
Repair: The extent (1:106984) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901495808 (type Unknown).
Repair: The extent (1:107928) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901495808 (type Unknown).
Repair: The extent (1:109400) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901495808 (type Unknown).
Repair: The extent (1:106400) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901561344 (type Unknown).
Repair: The extent (1:107168) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901561344 (type Unknown).
Repair: The extent (1:108016) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901561344 (type Unknown).
Repair: The extent (1:109080) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901561344 (type Unknown).
Repair: The extent (1:109344) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594901561344 (type Unknown).
Msg 8905, Level 16, State 1, Line 34
Extent (1:105840) in database ID 9 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
The error has been repaired.
Msg 8904, Level 16, State 1, Line 34
Extent (1:105880) in database ID 9 is allocated by more than one allocation object.
The error has been repaired.
....
....
....
....
CHECKDB found 14 allocation errors and 22 consistency errors in database 'Databaze'.
CHECKDB fixed 14 allocation errors and 0 consistency errors in database 'Databaze'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Databaze, repair_allow_data_loss).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Completion time: 2025-07-06T08:01:23.0437810-07:00<\/pre>\n\n\n\nalter database Databaze set online
go
alter database Databaze set multi_user
go<\/pre>\n\n\n\n