Welcome Guest, you are in: <root> • Login

Page History: MS-SQL LDF파일 축소

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2011/01/10 17:29

• DB 로그 비우기
  

backup log 디비명 With TRUNCATE_ONLY

• DB 정보보기
  

sp_helpdb 디비명



DBCC SHRINKFILE (test_log, 5)

예) backup log NewDerbyGame With TRUNCATE_ONLY sp_helpdb NewDerbyGame DBCC SHRINKFILE (NewDerbyGame_Log , 5)

Copyright © 2010 MUST Corp. All rights reserved. must@must.or.kr
This Program is released under the GNU General Public License v2. View the GNU General Public License v2 or visit the GNU website.