{"id":4747,"date":"2024-05-07T11:55:39","date_gmt":"2024-05-07T04:55:39","guid":{"rendered":"https:\/\/longvan.net\/cong-dong\/?p=4747"},"modified":"2024-11-27T12:51:47","modified_gmt":"2024-11-27T05:51:47","slug":"huong-dan-restore-du-lieu-mssql-bang-bussiness-backup-tren-window","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-restore-du-lieu-mssql-bang-bussiness-backup-tren-window\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn Restore d\u1eef li\u1ec7u MSSQL b\u1eb1ng Bussiness Backup tr\u00ean Window"},"content":{"rendered":"

Business Backup<\/a> l\u00e0 d\u1ecbch v\u1ee5 sao l\u01b0u (backup), kh\u00f4i ph\u1ee5c (restore) d\u1eef li\u1ec7u tr\u1ef1c tuy\u1ebfn, h\u1ed7 tr\u1ee3 backup c\u1ea3 file v\u00e0 \u1ee9ng d\u1ee5ng, c\u1ea3 server v\u00e0 desktop \u0111\u1ec1u \u0111\u01b0\u1ee3c. D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c n\u00e9n v\u00e0 m\u00e3 h\u00f3a, th\u01b0\u1eddng xuy\u00ean sao l\u01b0u th\u00e0nh nhi\u1ec1u phi\u00ean b\u1ea3n. Qu\u00e1 tr\u00ecnh backup, restore di\u1ec5n ra nhanh ch\u00f3ng m\u00e0 kh\u00f4ng g\u00e2y \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn ho\u1ea1t \u0111\u1ed9ng c\u1ee7a server<\/p>\n

Gi\u1ea3i ph\u00e1p sao l\u01b0u v\u00e0 kh\u00f4i ph\u1ee5c c\u01a1 s\u1edf d\u1eef li\u1ec7u t\u1ed1i \u01b0u cho doanh nghi\u1ec7p. Microsoft SQL Server (MSSQL) l\u00e0 h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd, ph\u00f9 h\u1ee3p cho nhi\u1ec1u quy m\u00f4 doanh nghi\u1ec7p
\nV\u1edbi hi\u1ec7u su\u1ea5t cao, b\u1ea3o m\u1eadt t\u1ed1t v\u00e0 d\u1ec5 t\u00edch h\u1ee3p, MSSQL h\u1ed7 tr\u1ee3 qu\u1ea3n l\u00fd giao d\u1ecbch, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh s\u1eb5n s\u00e0ng li\u00ean t\u1ee5c, gi\u00fap doanh nghi\u1ec7p v\u1eadn h\u00e0nh hi\u1ec7u qu\u1ea3 v\u00e0 ph\u00e1t tri\u1ec3n b\u1ec1n v\u1eefng.<\/p>\n

B\u00e0i vi\u1ebft n\u00e0y Long V\u00e2n s\u1ebd h\u01b0\u1edbng d\u1eabn Restore d\u1eef li\u1ec7u MSSQL b\u1eb1ng Bussiness Backup<\/a><\/p>\n

I. Restore tr\u00ean server \u0111\u00e3 c\u1ea5u h\u00ecnh Backup<\/h2>\n

B\u01b0\u1edbc 1: Truy c\u1eadp \u1ee9ng d\u1ee5ng AhsayOBM<\/h3>\n

-\u0110\u0103ng nh\u1eadp v\u00e0o t\u00e0i kho\u1ea3n Long V\u00e2n \u0111\u00e3 cung c\u1ea5p.<\/p>\n

\"\"<\/p>\n

-Ch\u1ecdn M\u1ee5c Restore, Sau \u0111\u00f3 ch\u1ecdn Backup Set mu\u1ed1n Restore v\u1ec1.<\/p>\n

B\u01b0\u1edbc 2: Ph\u1ea7n Select From Where To Restore,<\/h3>\n

-Ch\u1ecdn AhsayCBS nh\u01b0 h\u00ecnh.
\n\"\"<\/p>\n

B\u01b0\u1edbc 3: Ch\u1ecdn files, th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n Restore<\/h3>\n

-Ph\u1ea7n Select what to restore:<\/p>\n

    \n
  • Restore theo folder \u0111\u00e3 ch\u1ecdn ho\u1eb7c restore all files<\/li>\n
  • Ch\u1ecdn ng\u00e0y backup<\/li>\n
  • Ch\u1ecdn th\u1eddi gian backup<\/li>\n<\/ul>\n

    -Show filter \u0111\u1ec3 ch\u1ecdn th\u01b0 m\u1ee5c mu\u1ed1n restore v\u1ec1, ch\u1ecdn files mu\u1ed1n restore<\/p>\n

    \"\"<\/p>\n

    -Next \u0111\u1ec3 ti\u1ebfp t\u1ee5c.<\/p>\n

    B\u01b0\u1edbc 4: Ch\u1ecdn n\u01a1i l\u01b0u tr\u1eef file Restore<\/h3>\n

    -\u1ede ph\u1ea7n ti\u1ebfp theo s\u1ebd c\u00f3 2 options:<\/p>\n

      \n
    • Restore v\u00e0o Database \u0111\u00e3 c\u1ea5u h\u00ecnh Backup ban \u0111\u1ea7u.<\/li>\n
    • Restore ra m\u1ed9t th\u01b0 m\u1ee5c kh\u00e1c ( Click Browse \u0111\u1ec3 ch\u1ecdn n\u01a1i mu\u1ed1n restore ra)<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      B\u01b0\u1edbc 5: Ti\u1ebfn h\u00e0nh Restore<\/h3>\n

      -Sau khi \u0111\u00e3 ch\u1ecdn Option \u1edf b\u01b0\u1edbc 4, click v\u00e0o n\u00fat Restore \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ti\u1ebfn h\u00e0nh.<\/p>\n

      -\u0110\u1ee3i qu\u00e1 tr\u00ecnh Restore di\u1ec5n ra. Sau khi th\u00e0nh c\u00f4ng s\u1ebd c\u00f3 th\u00f4ng b\u00e1o Restore completed Successfully.
      \n\"\"
      \n-Nh\u01b0 v\u1eady l\u00e0 \u0111\u00e3 Restore th\u00e0nh c\u00f4ng !<\/p>\n

      II. Restore tr\u00ean server kh\u00e1c<\/h2>\n

      B\u01b0\u1edbc 1: Truy c\u1eadp \u1ee9ng d\u1ee5ng AhsayOBM<\/h3>\n

      -\u0110\u0103ng nh\u1eadp v\u00e0o t\u00e0i kho\u1ea3n Long V\u00e2n \u0111\u00e3 cung c\u1ea5p.<\/p>\n

      \"\"<\/p>\n

      -Ch\u1ecdn M\u1ee5c Restore, Sau \u0111\u00f3 ch\u1ecdn Backup Set mu\u1ed1n Restore v\u1ec1.<\/p>\n

      B\u01b0\u1edbc 2: Ph\u1ea7n Select From Where To Restore,<\/h3>\n

      -Ch\u1ecdn AhsayCBS nh\u01b0 h\u00ecnh.
      \n\"\"<\/p>\n

      B\u01b0\u1edbc 3: Ch\u1ecdn files, th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n Restore<\/h3>\n

      -Ph\u1ea7n Select what to restore:<\/p>\n

        \n
      • Restore theo folder \u0111\u00e3 ch\u1ecdn ho\u1eb7c restore all files<\/li>\n
      • Ch\u1ecdn ng\u00e0y backup<\/li>\n
      • Ch\u1ecdn th\u1eddi gian backup<\/li>\n<\/ul>\n

        -Show filter \u0111\u1ec3 ch\u1ecdn th\u01b0 m\u1ee5c mu\u1ed1n restore v\u1ec1, ch\u1ecdn files mu\u1ed1n restore<\/p>\n

        \"\"<\/p>\n

        -Next \u0111\u1ec3 ti\u1ebfp t\u1ee5c.<\/p>\n

        B\u01b0\u1edbc 4: Ch\u1ecdn n\u01a1i l\u01b0u tr\u1eef file Restore<\/h3>\n

        -Restore tr\u00ean 1 server kh\u00e1c th\u00ec ch\u1ec9 c\u00f3 1 opstion l\u00e0 Restore ra m\u1ed9t th\u01b0 m\u1ee5c kh\u00e1c<\/p>\n

        -Click Browse \u0111\u1ec3 ch\u1ecdn n\u01a1i mu\u1ed1n restore ra.<\/p>\n

        \"\"<\/p>\n

        B\u01b0\u1edbc 5: Ti\u1ebfn h\u00e0nh Restore<\/h3>\n

        -Sau khi \u0111\u00e3 ch\u1ecdn n\u01a1i l\u01b0u tr\u1eef \u1edf b\u01b0\u1edbc 4, click v\u00e0o n\u00fat Restore \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ti\u1ebfn h\u00e0nh.<\/p>\n

        -\u0110\u1ee3i qu\u00e1 tr\u00ecnh Restore di\u1ec5n ra. Sau khi th\u00e0nh c\u00f4ng s\u1ebd c\u00f3 th\u00f4ng b\u00e1o Restore completed Successfully.
        \n\"\"<\/p>\n

        B\u01b0\u1edbc 6: T\u1ea1o Database v\u1edbi t\u00ean t\u01b0\u01a1ng t\u1ef1 file backup<\/h3>\n

        -Truy c\u1eadp Microsoft SQL Server Managerment Studio sau \u0111\u00f3 k\u1ebft n\u1ed1i v\u00e0o DB.<\/p>\n

        -T\u1ea1o DB m\u1edbi.<\/p>\n

        \"\"<\/p>\n

        – T\u1ea1o t\u00ean gi\u1ed1ng<\/span> v\u1edbi DB file restore, v\u00e0 note<\/span> ph\u1ea7n \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ec3 l\u00fac sau ta thay \u0111\u1ed5i file restore.<\/p>\n

        \"\"<\/p>\n

        -Nh\u1ea5n OK \u0111\u1ec3 t\u1ea1o.<\/p>\n

        B\u01b0\u1edbc 7: Di chuy\u1ec3n file Restore v\u00e0o th\u01b0 m\u1ee5c c\u1ee7a SQL Server<\/h3>\n

        -Stop service SQL Server \u0111\u1ec3 copy. Truy c\u1eadp SQL Server Configuration Manager \u0111\u1ec3 stop<\/p>\n

        \"\"<\/p>\n

        -Sau khi Restore xong, file s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

        \"\"<\/p>\n

        -Ti\u1ebfn h\u00e0nh copy 2 file Database c\u00f3 \u0111u\u00f4i l\u00e0 .mdf v\u00e0 .ldf v\u00e0o th\u01b0 m\u1ee5c c\u1ee7a SQL Server<\/p>\n

        \"\"
        \n-V\u00e0o th\u01b0 m\u1ee5c c\u1ee7a SQL Server (\u0111\u01b0\u1eddng d\u1eabn \u0111\u00e3 note \u1edf b\u01b0\u1edbc 6)<\/span>
        \nC:\\Program Files\\Microsoft SQL Server\\MSSQL13.MSSQLSERVER\\MSSQL\\DATA<\/span><\/p>\n

        -Ti\u1ebfn h\u00e0nh Paste v\u00e0o th\u01b0 m\u1ee5c DATA c\u1ee7a SQL Server. Ch\u1ecdn Replace \u0111\u1ec3 ghi \u0111\u00e8 l\u00ean file c\u00f3 s\u1eb5n<\/p>\n

        \"\"<\/p>\n

        -Sau khi copy xong, ta ti\u1ebfn h\u00e0nh start c\u00e1c Service c\u1ee7a SQL Server.<\/p>\n

        \"\"<\/p>\n

        B\u01b0\u1edbc 8: Ki\u1ec3m tra d\u1eef li\u1ec7u Restore<\/h3>\n

        -Truy c\u1eadp Microsoft SQL Server Managerment Studio sau \u0111\u00f3 k\u1ebft n\u1ed1i v\u00e0o DB.<\/p>\n

          \n
        • Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u xem \u0111\u00e3 c\u1eadp nh\u1eadt \u0111\u1ea7y \u0111\u1ee7 kh\u00f4ng.<\/li>\n
        • Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u xem c\u00f3 b\u1ecb l\u1ed7i kh\u00f4ng.<\/li>\n<\/ul>\n

          \"\"<\/p>\n

          -Nh\u01b0 v\u1eady l\u00e0 qu\u00e1 tr\u00ecnh Restore ra server kh\u00e1c \u0111\u00e3 ho\u00e0n t\u1ea5t !<\/p>\n","protected":false},"excerpt":{"rendered":"

          Business Backup l\u00e0 d\u1ecbch v\u1ee5 sao l\u01b0u (backup), kh\u00f4i ph\u1ee5c (restore) d\u1eef li\u1ec7u tr\u1ef1c tuy\u1ebfn, h\u1ed7 tr\u1ee3 backup c\u1ea3 file v\u00e0 \u1ee9ng d\u1ee5ng, c\u1ea3 server v\u00e0 desktop \u0111\u1ec1u \u0111\u01b0\u1ee3c. D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c n\u00e9n v\u00e0 m\u00e3 h\u00f3a, th\u01b0\u1eddng xuy\u00ean sao l\u01b0u th\u00e0nh nhi\u1ec1u phi\u00ean b\u1ea3n. Qu\u00e1 tr\u00ecnh backup, restore di\u1ec5n ra nhanh ch\u00f3ng m\u00e0 kh\u00f4ng g\u00e2y […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[18],"tags":[275,297,200,65],"class_list":["post-4747","post","type-post","status-publish","format-standard","hentry","category-bussiness-backup","tag-bussiness-backup","tag-mssql","tag-restore","tag-windows"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=4747"}],"version-history":[{"count":12,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4747\/revisions"}],"predecessor-version":[{"id":7331,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4747\/revisions\/7331"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=4747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=4747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=4747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}