给你一个示例,联机帮助文档里有
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO
如:
BACKUP DATABASE PUBS
TO DISK = 'c:\PUBS' WITH INIT
恢复的语句如:
RESTORE DATABASE PUBS
FROM DISK = 'c:\PUBS'
不行呀。提示错误为:
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'TestDB' is not part of database 'TestDB'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.SQLServer2000的安装路径不一样,Restore database DBName from ....出错,在Enterprise Manager恢复时只要改数据文件和日志文件的路径就可以恢复的,但用SQL时如何获得当前SQLServer的数据文件和日志文件的路径?
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'