{"id":11349,"date":"2020-08-12T13:37:04","date_gmt":"2020-08-12T06:37:04","guid":{"rendered":"http:\/\/help.sme2020.misa.vn\/?post_type=ht_kb&#038;p=11349"},"modified":"2025-11-07T14:37:20","modified_gmt":"2025-11-07T07:37:20","slug":"lam-the-nao-khi-phuc-hoi-du-lieu-bao-loi","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/lam-the-nao-khi-phuc-hoi-du-lieu-bao-loi\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o khi ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u b\u00e1o l\u1ed7i?"},"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><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m, gi\u00fap ng\u01b0\u1eddi d\u00f9ng kh\u1eafc ph\u1ee5c nhanh ch\u00f3ng \u0111\u1ec3 ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng h\u1ec7 th\u1ed1ng.<br \/>\n<b>Bi\u1ec3u hi\u1ec7n:<\/b><\/p>\n<ul>\n<li>Khi ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u, ch\u01b0\u01a1ng tr\u00ecnh c\u1ea3nh b\u00e1o: L\u1ed7i ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/phuc-hoi_3-1.png\" alt=\"\" width=\"504\" height=\"417\" \/><\/p>\n<ul>\n<li>Ho\u1eb7c b\u00e1o l\u1ed7i: Ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u kh\u00f4ng th\u00e0nh c\u00f4ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/phuc-hoi_2.png\" alt=\"\" width=\"504\" height=\"416\" \/><\/p>\n<ul>\n<li>Ho\u1eb7c b\u00e1o l\u1ed7i: INCOMPLETE<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2023\/wp-content\/uploads\/2020\/08\/A1.png\" alt=\"\" width=\"438\" height=\"312\" \/><\/p>\n<p><b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u th\u01b0\u1eddng g\u1eb7p.<\/li>\n<li>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eebng tr\u01b0\u1eddng h\u1ee3p l\u1ed7i: do phi\u00ean b\u1ea3n SQL, file sao l\u01b0u b\u1ecb l\u1ed7i, ho\u1eb7c \u1ed5 \u0111\u0129a \u0111\u1ea7y.<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> Qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng, k\u1ef9 thu\u1eadt vi\u00ean, ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u <\/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><b>2. C\u00e1ch x\u1eed l\u00fd<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/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<h4><b>2.1. L\u1ed7i do b\u1ea3n sao l\u01b0u \u1edf phi\u00ean b\u1ea3n SQL cao h\u01a1n so v\u1edbi phi\u00ean b\u1ea3n SQL \u0111ang s\u1eed d\u1ee5ng tr\u00ean m\u00e1y t\u00ednh<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/b><br \/>\n<b>B\u01b0\u1edbc 1:<\/b> C\u00e0i SQL 2014. Xem h\u01b0\u1edbng d\u1eabn c\u00e0i SQL 2014 <a class=\"externalLink\" href=\"\/2023\/kb\/cai_dat_lai_sql\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a>.<br \/>\n<b>B\u01b0\u1edbc 2:<\/b> Ph\u1ee5c h\u1ed3i l\u1ea1i file sao l\u01b0u tr\u00ean SQL 2014 m\u1edbi v\u1eeba c\u00e0i \u0111\u1eb7t.<\/p>\n<ul>\n<li><em>V\u00ed d\u1ee5: SQL 2014 m\u1edbi c\u00e0i c\u00f3 t\u00ean<strong> Instance name<\/strong> l\u00e0 SQL2014. Khi \u0111\u0103ng nh\u1eadp v\u00e0o m\u00e1y ch\u1ee7, g\u00f5 l\u1ea1i t\u00ean theo c\u1ea5u tr\u00fac: <strong>t\u00ean m\u00e1y t\u00ednh\\t\u00ean SQL m\u1edbi<\/strong> (PMTAM\\SQL2014)<\/em><\/li>\n<li>Nh\u1ea5n <strong>\u0111\u1ed3ng \u00fd<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/12.png&quot;\" alt=\"\" width=\"740\" height=\"327\" \/><\/p>\n<ul>\n<li>Ti\u1ebfn h\u00e0nh ch\u1ecdn l\u1ea1i file v\u00e0 ph\u1ee5c h\u1ed3i l\u1ea1i d\u1eef li\u1ec7u.<\/li>\n<\/ul>\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<h4><b>2.2. L\u1ed7i do file sao l\u01b0u b\u1ecb l\u1ed7i ho\u1eb7c kh\u00f4ng \u0111\u1ea7y \u0111\u1ee7<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/b> T\u00ecm file sao l\u01b0u kh\u00e1c ho\u1eb7c sao l\u01b0u l\u1ea1i (n\u1ebfu l\u1ea5y t\u1eeb m\u00e1y t\u00ednh kh\u00e1c sang) r\u1ed3i th\u1ef1c hi\u1ec7n ph\u1ee5c h\u1ed3i l\u1ea1i. <\/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<h4><b>2.3. L\u1ed7i do dung l\u01b0\u1ee3ng \u1ed5 \u0111\u0129a l\u01b0u tr\u1eef b\u1ecb \u0111\u1ea7y<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/b><br \/>\nKhi ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u, t\u1ea1i d\u00f2ng <strong>\u0110\u01b0\u1eddng d\u1eabn l\u01b0u tr\u1eef DLKT<\/strong> ki\u1ec3m tra \u1ed5 \u0111\u0129a \u0111ang s\u1eed d\u1ee5ng. N\u1ebfu \u1ed5 \u0111\u0129a \u0111\u00f3 \u0111\u1ea7y, d\u1ecdn d\u1eb9p l\u1ea1i \u1ed5 \u0111\u0129a ho\u1eb7c ch\u1ecdn ph\u1ee5c h\u1ed3i sang \u1ed5 \u0111\u0129a kh\u00e1c c\u00f2n dung l\u01b0\u1ee3ng.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2023\/wp-content\/uploads\/2020\/08\/A2.jpg\" alt=\"\" width=\"517\" height=\"440\" \/><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2642],"ht-kb-tag":[3588,4929],"class_list":["post-11349","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-sql-server","ht_kb_tag-incomplete","ht_kb_tag-phuc-hoi-du-lieu-bao-loi"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11349","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\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=11349"}],"version-history":[{"count":6,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11349\/revisions"}],"predecessor-version":[{"id":55567,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11349\/revisions\/55567"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=11349"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=11349"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=11349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}