{"id":1429,"date":"2018-12-25T17:51:55","date_gmt":"2018-12-25T10:51:55","guid":{"rendered":"http:\/\/help.sme2019.misa.local\/?post_type=ht_kb&#038;p=1429"},"modified":"2025-10-23T11:31:14","modified_gmt":"2025-10-23T04:31:14","slug":"restart_lai_sql_server","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/restart_lai_sql_server\/","title":{"rendered":"Restart l\u1ea1i SQL Server"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 SQL Server nh\u1eb1m kh\u1eafc ph\u1ee5c c\u00e1c s\u1ef1 c\u1ed1 k\u1ebft n\u1ed1i ho\u1eb7c l\u1ed7i ph\u00e1t sinh khi s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n, \u0111\u1ea3m b\u1ea3o h\u1ec7 th\u1ed1ng v\u1eadn h\u00e0nh li\u00ean t\u1ee5c v\u00e0 \u1ed5n \u0111\u1ecbnh.<\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong> H\u01b0\u1edbng d\u1eabn x\u00e1c \u0111\u1ecbnh \u0111\u00fang d\u1ecbch v\u1ee5 SQL Server c\u1ea7n kh\u1edfi \u0111\u1ed9ng l\u1ea1i, c\u00e1c ph\u01b0\u01a1ng ph\u00e1p ki\u1ec3m tra th\u00f4ng tin SQL Server v\u00e0 thao t\u00e1c restart d\u1ecbch v\u1ee5.<\/p>\n<p><strong>Ph\u1ea1m vi \u0111\u00e1p \u1ee9ng:<\/strong>\u00a0\u00c1p d\u1ee5ng cho doanh nghi\u1ec7p, b\u1ed9 ph\u1eadn IT, c\u00e1 nh\u00e2n ho\u1eb7c anh\/ch\u1ecb k\u1ebf to\u00e1n c\u1ea7n x\u1eed l\u00fd s\u1ef1 c\u1ed1 ho\u1eb7c b\u1ea3o tr\u00ec h\u1ec7 th\u1ed1ng ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n s\u1eed d\u1ee5ng SQL Server.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 1:<\/strong><span style=\"color: black;\"><span style=\"color: black;\">\u00a0V\u00e0o <strong>All Programs\\Microsoft SQL Server 2014\\Configuration Tools\\SQL Server Configuration Manager<\/strong>.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26709\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/sql_5.png\" alt=\"\" width=\"820\" height=\"479\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/sql_5.png 820w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-700x409.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-800x467.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-768x449.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-50x29.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-60x35.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/sql_5-100x58.png 100w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/span><\/p>\n<p><span style=\"color: black; font-size: 12pt;\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ee5c <strong>SQL Server Services<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26703\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/sql_3.png\" alt=\"\" width=\"711\" height=\"402\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/sql_3.png 711w, \/2023\/wp-content\/uploads\/2018\/12\/sql_3-700x396.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/sql_3-50x28.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/sql_3-60x34.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/sql_3-100x57.png 100w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><\/p>\n<p><span style=\"color: black; font-size: 12pt;\"><strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn <strong>SQL Server<\/strong> c\u1ea7n Restart. \u0110\u1ec3 bi\u1ebft th\u00f4ng tin <strong>SQL Server<\/strong>, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: 12pt;\">C\u00e1ch 1: Ki\u1ec3m tra tr\u00ean giao di\u1ec7n \u0111\u0103ng nh\u1eadp v\u00e0o ph\u1ea7n m\u1ec1m:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26701\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/sql_2.png\" alt=\"\" width=\"774\" height=\"506\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/sql_2.png 774w, \/2023\/wp-content\/uploads\/2018\/12\/sql_2-700x458.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/sql_2-768x502.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/sql_2-50x33.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/sql_2-60x39.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/sql_2-100x65.png 100w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/span><\/p>\n<ul>\n<li><span style=\"font-size: 12pt;\">C\u00e1ch 2: Ki\u1ec3m tra tr\u00ean giao di\u1ec7n t\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26699\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/sql_1.png\" alt=\"\" width=\"803\" height=\"602\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/sql_1.png 803w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-700x525.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-800x600.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-768x576.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-50x37.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-60x45.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/sql_1-100x75.png 100w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/span><\/p>\n<p><span style=\"color: black; font-size: 12pt;\"><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Restart<\/strong>, v\u00e0 \u0111\u1ee3i \u0111\u1ebfn khi qu\u00e1 tr\u00ecnh Restart ho\u00e0n th\u00e0nh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26705\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/sql_4.png\" alt=\"\" width=\"891\" height=\"402\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/sql_4.png 891w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-700x316.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-800x361.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-768x347.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-50x23.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-60x27.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/sql_4-100x45.png 100w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/p>\n<\/div><\/div>\n<\/div><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"img-size80\" src=\"\/2022\/wp-content\/uploads\/2019\/12\/R4_sqlserver_01\" alt=\"\" \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":120,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2608],"ht-kb-tag":[3967,3969],"class_list":["post-1429","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-khac-huong-dan-4__khac","ht_kb_tag-khoi-dong-lai-sql-server","ht_kb_tag-restart-sql"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=1429"}],"version-history":[{"count":4,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1429\/revisions"}],"predecessor-version":[{"id":43617,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1429\/revisions\/43617"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=1429"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=1429"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=1429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}