{"id":168,"date":"2011-07-21T14:17:02","date_gmt":"2011-07-21T07:17:02","guid":{"rendered":"http:\/\/www.cpanel.vn\/?p=168"},"modified":"2011-07-21T14:18:05","modified_gmt":"2011-07-21T07:18:05","slug":"how-to-truncate-log-file-in-sql-server-2005-giam-dung-luong-log-file-trong-sql-server-2005","status":"publish","type":"post","link":"https:\/\/cpanel.vn\/?p=168","title":{"rendered":"X\u00f3a Log File trong SQL Server 2005"},"content":{"rendered":"

How to Truncate Log File in SQL Server 2005 – Gi\u1ea3m dung l\u01b0\u1ee3ng Log File trong SQL Server 2005<\/strong><\/p>\n

SQL Server 2005 c\u00f3 kh\u00e1 nhi\u1ec1u \u0111i\u1ec3m kh\u00e1c bi\u1ec7t v\u1edbi SQL Server 2000. M\u1ed9t trong nh\u1eefng \u0111i\u1ec3m \u0111\u00f3 l\u00e0 vi\u1ec7c thu nh\u1ecf dung l\u01b0\u1ee3ng file Log (*.LDF)<\/p>\n

Trong SQL 2000, b\u1ea1n ch\u1ec9 c\u1ea7n Shrink v\u1edbi b\u1ea5t c\u1ee9 k\u00edch th\u01b0\u1edbc n\u00e0o b\u1ea1n mu\u1ed1n. C\u00f2n v\u1edbi SQL Server 2005, \u0111\u00f4i khi b\u1ea1n kh\u00f4ng th\u1ec3 Shrink \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u.<\/p>\n

B\u00e0i vi\u1ebft n\u00e0y cPanel.vn h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng file Log c\u1ee7a SQL. M\u00f4i tr\u01b0\u1eddng l\u00e0m vi\u1ec7c l\u00e0 Microsoft SQL Server Management Studio.<\/p>\n

C\u00e1ch 1: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng shrink<\/strong><\/span><\/p>\n

Chu\u1ed9t ph\u1ea3i v\u00e0o database b\u1ea1n c\u1ea7n Shrink, ch\u1ecdn Tasks<\/strong>, ch\u1ecdn ti\u1ebfp Shrink<\/strong> v\u00e0 cu\u1ed1i c\u00f9ng ch\u1ecdn Files<\/strong>.
\nB\u1ea1n tick v\u00e0o Reorganize pages before releasing unused space v\u00e0 set dung l\u01b0\u1ee3ng file. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 1M<\/p>\n\\\"\\\"<\/a>\n

C\u00e1ch 2: X\u00f3a file log.<\/strong><\/span><\/p>\n

\u0110\u00f4i khi, b\u1ea1n l\u00e0m theo c\u00e1ch 1 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c. B\u1ea3n th\u00e2n ng\u01b0\u1eddi vi\u1ebft c\u0169ng \u0111\u00e3 nhi\u1ec1u l\u1ea7n g\u1eb7p tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng shrink \u0111\u01b0\u1ee3c database. File log qu\u00e1 l\u1edbn.
\nC\u00e1ch d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd v\u1ea5n \u0111\u1ec1 n\u00e0y, l\u1ea5y l\u1ea1i ph\u1ea7n \u1ed5 c\u1ee9ng b\u1ecb chi\u1ebfm d\u1ee5ng m\u1ed9t c\u00e1ch ph\u00ed ph\u1ea1m.<\/p>\n

    \n
  1. \u0110\u1ec3 an to\u00e0n, lu\u00f4n n\u00ean backup database tr\u01b0\u1edbc khi b\u1ea1n l\u00e0m b\u1ea5t c\u1ee9 thao t\u00e1c g\u00ec.<\/li>\n
  2. Chu\u1ed9t ph\u1ea3i v\u00e0o database c\u1ea7n x\u1eed l\u00fd, ch\u1ecdn Tasks –> Detach.<\/li>\n
  3. M\u1edf folder ch\u1ee9a log file c\u1ee7a database (file .LDF<\/strong>), rename n\u00f3 \u0111i. V\u00ed d\u1ee5: cpanel_web.LDF<\/strong> \u0111\u1ed5i th\u00e0nh cpanel_web_backup.LDF<\/strong><\/li>\n
  4. Ti\u1ebfn h\u00e0nh Attach l\u1ea1i database c\u1ee7a b\u1ea1n. Khi add file .MDF, n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ea5y lu\u00f4n file LDF \u0111i k\u00e8m. B\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m chu\u1ed9t v\u00e0o d\u00f2ng file LDF \u0111\u00f3 v\u00e0 b\u1ea5m n\u00fat Remove. H\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 t\u1ea1o l\u1ea1i cho b\u1ea1n file LDF m\u1edbi.<\/li>\n
  5. Cu\u1ed1i c\u00f9ng, ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. N\u1ebfu m\u1ecdi vi\u1ec7c \u1ed5n r\u1ed3i b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a file LDF c\u0169 \u0111i<\/li>\n<\/ol>\n

    C\u00e1ch tr\u00ean hy v\u1ecdng s\u1ebd gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf c\u00e1c file LDF dung l\u01b0\u1ee3ng l\u1edbn, l\u1ea5y l\u1ea1i \u1ed5 c\u1ee9ng cho b\u1ea1n.
    \nCh\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

    How to Truncate Log File in SQL Server 2005 – Gi\u1ea3m dung l\u01b0\u1ee3ng Log File trong SQL Server 2005 SQL Server 2005 c\u00f3 kh\u00e1 nhi\u1ec1u \u0111i\u1ec3m kh\u00e1c bi\u1ec7t v\u1edbi SQL Server 2000. M\u1ed9t trong nh\u1eefng \u0111i\u1ec3m \u0111\u00f3 l\u00e0 vi\u1ec7c thu nh\u1ecf dung l\u01b0\u1ee3ng file Log (*.LDF) Trong SQL 2000, b\u1ea1n ch\u1ec9 c\u1ea7n Shrink v\u1edbi b\u1ea5t […]<\/p>\n","protected":false},"author":1,"featured_media":170,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[95,94,99,96,60,98,97],"class_list":["post-168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mssql","tag-delete-ldf-file","tag-delete-log-file","tag-gim-dung-lng-file-log","tag-log","tag-mssql-2005","tag-sql-server-2005","tag-truncate"],"_links":{"self":[{"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/posts\/168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanel.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=168"}],"version-history":[{"count":0,"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/posts\/168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanel.vn\/index.php?rest_route=\/wp\/v2\/posts\/170"}],"wp:attachment":[{"href":"https:\/\/cpanel.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanel.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanel.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}