用什么DOS命令挂上*.mdf、*.ldf的数据库?

如题,试举一例,数据库为possn_data.mdf、possn_log.ldf
---------------------------------------------------------------

1:
用写字板新建一文本文件
EXEC sp_attach_db @dbname = N'possn',
@filename1 = N'c:\Data\possn_data.mdf',
@filename2 = N'c:\Data\possn_log.ldf'

2:另存为一个脚本文件,eg: c:\aa.sql

3:用isql调用,在命令行(MS-DOS方式)下执行如下语句即可
isql -S 服务器名 -U sa -P 密码 -i "c:\aa.sql"

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus