2006-12-09
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
...
- Items 1 - 1
- 1
Recent Comments
EnZo@2012-02-09
bobby@2012-02-04
Jose Lorenzo@2012-02-03
guest@2012-01-23
srikanth@2012-01-22
rui@2012-01-17
Zack Kitzmiller@2012-01-13
guest@2012-01-13
guest@2012-01-13
guest@2012-01-13