RESTORE DATABASE vds
FROM DISK = 'D:\20011228.bak'
WITH MOVE '原库名' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\vds.mdf',
MOVE '原库名_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\vds_log.ldf'
GO这里C:\Program Files\Microsoft SQL Server\MSSQL为你安装SQL的目录。
FROM DISK = 'D:\20011228.bak'
WITH MOVE '原库名' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\vds.mdf',
MOVE '原库名_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\vds_log.ldf'
GO这里C:\Program Files\Microsoft SQL Server\MSSQL为你安装SQL的目录。
RESTORE DATABASE vds
FROM DISK='D:\20011228.bak'
WITH MOVE 'vds' TO 'D:\MSSQL7\Data\vds.mdf',
MOVE 'vds_log' TO 'D:\MSSQL7\Data\vds_log.ldf'
GO运行结果如下:
Server: Msg 3624, Level 20, State 1, Line 1
Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 8
Process ID: -24589Connection Broken请问这是怎么回事?
打开企业管理器---新建一个数据库---右击选择还原数据库----选择从设备(选择添加,选择.bak文件)----确定---从选项中选择在现有数据库上强制还原----确定