{"id":39251,"date":"2025-02-17T14:08:41","date_gmt":"2025-02-17T07:08:41","guid":{"rendered":"https:\/\/helpsme.misa.vn\/2023\/?post_type=ht_kb&#038;p=39251"},"modified":"2025-11-07T15:55:58","modified_gmt":"2025-11-07T08:55:58","slug":"lam-the-nao-khi-thuc-hien-ghi-sobo-ghi-them-moi-cat-chung-tu-phan-mem-canh-bao-because-the-primary","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/lam-the-nao-khi-thuc-hien-ghi-sobo-ghi-them-moi-cat-chung-tu-phan-mem-canh-bao-because-the-primary\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o khi th\u1ef1c hi\u1ec7n Ghi s\u1ed5, B\u1ecf ghi, Th\u00eam m\u1edbi, C\u1ea5t ch\u1ee9ng t\u1eeb ph\u1ea7n m\u1ec1m c\u1ea3nh b\u00e1o:&#8230;.because the &#8216;PRIMARY&#8217;&#8230;"},"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 l\u1ed7i kh\u00f4ng ghi s\u1ed5 ho\u1eb7c kh\u00f4ng c\u1ea5t \u0111\u01b0\u1ee3c ch\u1ee9ng t\u1eeb do ph\u1ea7n m\u1ec1m b\u00e1o l\u1ed7i System.Data.SqlException (0x80131904)&#8230;because the &#8216;PRIMARY&#8217; filegroup is full&#8230; tr\u00ean ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2023\/wp-content\/uploads\/2025\/02\/upload_2020-7-8_8-41-38.png\" alt=\"\" width=\"399\" height=\"446\" \/><br \/>\n<b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p x\u1eed l\u00fd l\u1ed7i do \u1ed5 l\u01b0u tr\u1eef d\u1eef li\u1ec7u b\u1ecb \u0111\u1ea7y<\/li>\n<li>Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p khi dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u v\u01b0\u1ee3t qu\u00e1 10 GB<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> Qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng, K\u1ebf to\u00e1n tr\u01b0\u1edfng, Ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd 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. Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p<\/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 Tr\u01b0\u1eddng h\u1ee3p 1: Do \u1ed5 l\u01b0u tr\u1eef d\u1eef li\u1ec7u b\u1ecb \u0111\u1ea7y n\u00ean kh\u00f4ng thao t\u00e1c c\u1ea5t ho\u1eb7c ghi s\u1ed5 ch\u1ee9ng t\u1eeb \u0111\u01b0\u1ee3c<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>Gi\u1ea3i ph\u00e1p:<\/b><br \/>\nKi\u1ec3m tra th\u01b0 m\u1ee5c ch\u1ee9a d\u1eef li\u1ec7u g\u1ed1c b\u1eb1ng c\u00e1ch sau (n\u1ebfu d\u00f9ng m\u00f4 h\u00ecnh m\u00e1y tr\u1ea1m\/ch\u1ee7 th\u00ec ki\u1ec3m tra \u1edf M\u00e1y ch\u1ee7):<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o <strong style=\"font-family: inherit; font-size: inherit;\">T\u1ec7p\/Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u\/<\/strong><span style=\"font-family: inherit; font-size: inherit;\">Nh\u1ea5n <\/span><strong style=\"font-family: inherit; font-size: inherit;\">\u0110\u1ed3ng \u00fd<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2023\/wp-content\/uploads\/2025\/02\/aa1.png\" alt=\"\" width=\"406\" height=\"218\" \/><\/p>\n<p><span style=\"font-family: inherit; font-size: inherit;\"><strong>B\u01b0\u1edbc 2: <\/strong>T\u1ea1i d\u00f2ng t\u00ean d\u1eef li\u1ec7u, xem \u0111\u01b0\u1eddng d\u1eabn t\u1ea1i c\u1ed9t <\/span><strong style=\"font-family: inherit; font-size: inherit;\">T\u1ec7p d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/strong><span style=\"font-family: inherit; font-size: inherit;\"> \u0111\u1ec3 bi\u1ebft d\u1eef li\u1ec7u g\u1ed1c l\u01b0u \u1edf \u1ed5 \u0111\u0129a n\u00e0o.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2023\/wp-content\/uploads\/2024\/04\/2024-04-02_16-57-59.png\" alt=\"\" width=\"1265\" height=\"141\" \/><span style=\"font-family: inherit; font-size: inherit;\"><strong>B\u01b0\u1edbc 3:<\/strong> Ki\u1ec3m tra \u1ed5 \u0111\u0129a (c\u1ea3 \u1ed5 C v\u00e0 c\u1ea3 \u1ed5 n\u01a1i l\u01b0u tr\u1eef d\u1eef li\u1ec7u) n\u1ebfu b\u1ecb \u0111\u1ea7y th\u00ec khi th\u1ef1c hi\u1ec7n x\u00f3a b\u1edbt c\u00e1c file trong \u1ed5 kh\u00f4ng c\u1ea7n d\u00f9ng \u0111\u1ebfn \u0111\u1ec3 l\u00e0m tr\u1ed1ng \u1ed5.<\/span><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> N\u1ebfu \u1ed5 l\u01b0u tr\u1eef d\u1eef li\u1ec7u c\u0169ng l\u00e0 \u1ed5 sao l\u01b0u d\u1eef li\u1ec7u backup h\u00e0ng ng\u00e0y th\u00ec c\u00f3 th\u1ec3 x\u00f3a b\u1edbt c\u00e1c b\u1ea3n sao l\u01b0u kh\u00f4ng c\u1ea7n thi\u1ebft \u0111\u1ec3 d\u1ecdn d\u1eb9p \u1ed5 theo h\u01b0\u1edbng d\u1eabn <a style=\"font-family: inherit; font-size: inherit;\" href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/toi-can-xoa-bot-file-sao-luu-tren-may-tinh-do-o-dia-bi-day-thi-lam-the-nao\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><span style=\"font-family: inherit; font-size: inherit;\"><br \/>\n<\/span> <\/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 Tr\u01b0\u1eddng h\u1ee3p 2: Dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111ang v\u01b0\u1ee3t qu\u00e1 10 GB<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>Gi\u1ea3i ph\u00e1p:<\/b><\/p>\n<ul>\n<li>Ki\u1ec3m tra v\u00e0 l\u00e0m theo h\u01b0\u1edbng d\u1eabn c\u1ee7a <strong>Tr\u01b0\u1eddng h\u1ee3p 2<\/strong> theo link <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/lam_the_nao_de_chay_tot_phan_mem_khi_du_lieu_lon\/#truong-hop-2-dung-luong-du-lieu-tren-10gb\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a>.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":124,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2620],"ht-kb-tag":[],"class_list":["post-39251","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-lap-chung-tu"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/39251","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\/124"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=39251"}],"version-history":[{"count":6,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/39251\/revisions"}],"predecessor-version":[{"id":55761,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/39251\/revisions\/55761"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=39251"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=39251"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=39251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}