ruilog
Notebook
Blog
About
Content Explore
如何导入MDF数据到 SQL server
Published : 2006-12-09
Categories :
Tech
Tags :
SQL Server
mdf
Import
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:\......\te...
1
Categories
All
Other
Private
School
Software
Tech
SmartKit
Marathon
Trip
Relax
Life