Skip to content
January 7, 2014 / windperson

Attach only .mdf DB file in SQL Server

use the following T-SQL script:

USE [master]
GO

EXEC sp_attach_single_file_db @dbname='DB_Name_You_desire',
@physname=N'The_Physical_Path_of_the_mdf_file'
GO

The accompany .ldf log file will be auto created.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: