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

MS-SQL LDF파일 축소

RSS
Modified on 2012/05/17 20:48 by Administrator Categorized as Database
  • 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)

windows 2008

alter database DBNAME 
set recovery simple;
go

DBCC SHRINKFILE ('DBNAME _Log', 2)
go

alter database DBNAME 
set recovery full;
go

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.