Welcome Guest, you are in: Login

MUST Creative Engineering Laboratory

RSS RSS

Navigation



Technical Doc



Search the wiki
»

MUST Corp.

MUST Corp.

www.must.or.kr

 Microsoft CERTIFIED Partner Software Development, Web Development, Data Platform

 Microsoft Small Business Specialist

MCSD

Microsoft Certified IT Professional

Microsoft Certified Professional Developer

Page History: MS-SQL LDF파일 축소

Compare Page Revisions



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


Page Revision: 2011/01/10 17:30


  • DB 로그 비우기

backup log 디비명 With TRUNCATE_ONLY



  • DB 정보보기

sp_helpdb 디비명



DBCC SHRINKFILE (test_log, 5)

예) backup log DBNAME With TRUNCATE_ONLY

sp_helpdb DBNAME

DBCC SHRINKFILE (DBNAME_Log , 5)

MUST Creative Engineering Laboratory

ImageImage Image Image

Image Image Image Image Image Image Image

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.