use master create database yourdb_name (on primary filename='物理数据库的路径+名称') for attach
除上面方法,还可以通过如下实现 use master RESTORE FILELISTONLY FROM DISK = 'd:\mssql7\back up\dfdb.bak' RESTORE DATABASE dfdb FROM DISK = 'd:\mssql7\back up\dfsndb.bak'注:d:\mssql7\back up\ 指SQL7的安装路径,在SQL2000下,需建一同样路径 既d:\mssql7\Data
create database yourdb_name
(on primary filename='物理数据库的路径+名称')
for attach
use master
RESTORE FILELISTONLY FROM DISK = 'd:\mssql7\back up\dfdb.bak'
RESTORE DATABASE dfdb FROM DISK = 'd:\mssql7\back up\dfsndb.bak'注:d:\mssql7\back up\ 指SQL7的安装路径,在SQL2000下,需建一同样路径
既d:\mssql7\Data
7.0和2000数据库是兼容的.