语句写错了
以pubs数据库为例:BACKUP DATABASE pubs
TO DISK = 'c:\pubs.bak' RESTORE DATABASE pubs
FROM DISK = 'c:\pubs.bak'
以pubs数据库为例:BACKUP DATABASE pubs
TO DISK = 'c:\pubs.bak' RESTORE DATABASE pubs
FROM DISK = 'c:\pubs.bak'
刚才我试着了一下。
没问题的
use pubs
go
create table test
(id int,
score int
)
insert into test values(1,100)
go
BACKUP DATABASE pubs
TO DISK = 'c:\pubs.bak'
drop database pubs
go
RESTORE DATABASE pubs
FROM DISK = 'c:\pubs.bak'
use pubs
go
select * from test存在TEST表。
BACKUP DATABASE pubs TO DISK = '\xxx.bak'
我是先检测所要恢复的数据库是否存在,如果不存在先创建:
create database pubs
restore database pubs from disk='c:\aa'