如何导入MDF数据到 SQL server

2006-12-09 17:53:36 Tech Views(4905)

mdf文件如何导入到sql server数据库
1.停掉 MSSQLSERVER, 将安装目录下C:\ProgramFile\MSS\MSSQL\Data\test.mdf 和 test_log.ldf文件移走
2.重启 MSSQLSERVER, 删除PUBS
3.将MDF文件移到安装目录下
4.在SQL查询分析器肿执行exec sp_attach_db 'test', 'C:\......\test.mdf'
5.重启 SQL server

Tags:   SQL Server  mdf  Import

Comments

Leave a Comment

Name
Content
Verification Type the characters you see in the picture below