软件开发培训班 >> 编程开发 >> SQL


mdf文件和ldf文件导入到sql server 2005实现语句

　　本文标签：mdf,ldf,导入

复制代码 代码如下:

USE master;
Go
EXEC sp_attach_db @dbname = N数据库名,
@filename1 = N完整目录的mdf文件,
@filename2 = N完整目录的ldf文件;
GO

如
USE master;
Go
EXEC sp_attach_db @dbname = Ndb_shop, //db_shop是数据库名字
@filename1 = NE:\TM\07\Database\db_shop_Data.MDF,
@filename2 = NE:\TM\07\Database\db_shop_Log.LDF;
GO