登陆进入osql模式:RESTORE DATABASE MyNwind FROM MyNwind_1这是还原完整数据库备份的,MyNwind_1是备份文件!
--请使用下列语句: RESTORE FILELISTONLY FROM DISK = 'c:\AAA.bak' RESTORE DATABASE AAA FROM DISK = 'c:\AAA.bak' WITH MOVE 'AAA' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\AAA.mdf', MOVE 'AAA_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\AAA_Log.ldf'--假设: 1,备份文件在“C:”盘;2,SQL Server 2000安装在“C:”盘。
FROM MyNwind_1这是还原完整数据库备份的,MyNwind_1是备份文件!
RESTORE FILELISTONLY
FROM DISK = 'c:\AAA.bak'
RESTORE DATABASE AAA
FROM DISK = 'c:\AAA.bak'
WITH MOVE 'AAA' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\AAA.mdf',
MOVE 'AAA_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\AAA_Log.ldf'--假设: 1,备份文件在“C:”盘;2,SQL Server 2000安装在“C:”盘。