我发现这里0分的问题就很少有人回答。
你的数据库是2005还2000?RESTORE DATABASE [B] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\A.bak' WITH FILE = 1, MOVE N'testDB' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf', MOVE N'testDB_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b_log.ldf', NOUNLOAD, REPLACE, STATS = 10
GO
你的数据库是2005还2000?RESTORE DATABASE [B] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\A.bak' WITH FILE = 1, MOVE N'testDB' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf', MOVE N'testDB_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b_log.ldf', NOUNLOAD, REPLACE, STATS = 10
GO
选项:WITH FILE = 1, 一个备份设备上有多个备份集
选项:MOVE N'testDB' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf',
选项:MOVE N'testDB_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b_log.ldf',
选项:NOUNLOAD, REPLACE, STATS = 10
GO这样你看的明白吗?