怎样把拷出的SQL Server7.0 的数据库文件， 恢复到数据库系统中去？(50分)

我把原先的数据库文件（*.mdf,*.ldf) 移了个存储目录， 不知怎样同数据库
系统中的原先的数据库联系上。
望各位大侠帮忙。

哈哈
给分
先把数据库删掉，
然后执行存储过程sp_attach_db
语法：
sp_attach_db [@dbname =] 'dbname',
[@filename1 =] 'filename_n' [,...16]
Arguments
[@dbname =] 'dbname'
Is the name of the database to be attached to the server. The name must be unique. dbname is sysname, with a default of NULL.
[@filename1 =] 'filename_n'
Is the physical name, including path, of a database file. filename_n is nvarchar(260), with a default of NULL. There can be up to 16 file names specified. The parameter names start at @filename1 and increment to @filename16. The file name list must include at least the primary file, which contains the system tables that point to other files in the database. The list must also include any files that were moved after the database was detached.
Return Code Values
0 (success) or 1 (failure)
Result Sets
None

如果把此数据库文件移至另一个系统中, 能用此语句建立一个数据库的复制吗?
用此方法是不是只要备份了这两个数据库文件, 就不怕系统瘫痪, 甚至于硬盘坏了
也不愁了.

sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation. If more than 16 files must be specified, use CREATE DATABASE with the FOR ATTACH clause.
If you attach a database to a server other than the server from which the database was detached, and the detached database was enabled for replication, you should run sp_removedbreplication to remove replication from the database.

怎么找不到sp_attach_db's help.

<<如果把此数据库文件移至另一个系统中, 能用此语句建立一个数据库的复制吗?
用此方法是不是只要备份了这两个数据库文件, 就不怕系统瘫痪, 甚至于硬盘坏了
也不愁了
是这样的，这两个数据库文件包括了所有的东西，数据、存储过程，触发器，什么都
有，不过备份麻烦一点，要重起并让你的Server manager关闭。否则就共享冲突。
导入这样写：
Exec sp_attach_db '数据库名',
'路径/****（文件名）.MDF',
'路径/****（文件名）.LDF'

Server Manager都关了, 就是不能拷,
怎么办?
多谢各位.

wrench 到处推荐此方法.
这是重建系统最好的办法.我就经常用.在公司做好项目,给客户安装时最管用.比
备份/恢复好.
关于帮助,最好多看 sql books online
此方法不能代替复制.

用SQL Server enterprise Manager 或 service manager
停止 SQL SERVER 服务.
或者在 控制面板-服务 中停止.

能否把数据库的Backup 文件(MSSQL70/Backup/目录下的备份) 拷入另一系统进行
Restore 恢复?

http://www.gislab.ecnu.edu.cn/delphibbs/DispQ.asp?LID=215751

第一个问题还是wuzhengzheng 一针见血，

多人接受答案了。