Category Archives: Attach database without log file

Attaching a database without log file

To attach a database without a log file is to use a simple T-SQL as below: I am taking an example of AdventureWorks 2008R2 database to attach without a log file; T-Sql as below: CREATE DATABASE AdventureWorks ON (FILENAME =’C:\Database\Data\AdventureWorks2008R2_Data.mdf’) … Continue reading

Posted in Attach database without log file, SQL Server | Tagged , | Leave a comment