“常用公式”在线计算,“设计手册”在线查询
楼主
薛志杰 认证专家 发表于 2013-9-9 23:26:07 | 显示全部楼层
3、If a database has amissing log file, OR if it won't attach because the .MDF and .LDF files werecopied from a machine where they hadn't been detached first, you cansuccessfully attach the database by:1.)Delete the logfile (if it exists)2.)Make sure the.MDF file is in an accessible location like C:\FlowmasterV7\Data3.)Run the followingSQL query from inside SQL management studio express:SP_ATTACH_SINGLE_FILE_DB'Flowmaster','C:\FlowmasterV7\Data\Flowmaster_Data.MDF'Click execute. Thisquery will generate a new, empty log file and attach the database. You mighthave to click "refresh" the server view to see the new database.
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关注我们

360网站安全检测平台