트랜잭션 로그 파일 없이 복구하기

참고 링크 : http://www.mssqltips.com/tip.asp?tip=1894

-- Using T-SQL - Attach a SQL Server Database without a Transaction Log File

SELECT @@VERSION

GO

 

--Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)

--          Mar 29 2009 10:27:29

--          Copyright (c) 1988-2008 Microsoft Corporation

--          Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

 

execute sp_detach_db 'LOGTEST2'

go

 

CREATE DATABASE LOGTEST2

ON

(FILENAME = N'D:\logTest.mdf')

FOR ATTACH

GO

 

DBCC CHECKDB ('LOGTEST2')

GO