这是我成功的命令,仅作参考
对于我的失败,手动无法成功,所以用命令尝试了一下
Use rr
CREATE TABLE uu(
Sno CHAR(10),
Sname CHAR(10) NOT NULL,
Ssex CHAR(4) NOT NULL CHECK(Ssex in('男','女')),
Sage INT NOT NULL,
Spol CHAR(8),
Snat CHAR(12),
Sdept CHAR(20),
PRIMARY KEY(sno),
)
GO
select * from
Use rr
insert into uu values('09110103','汪琪','女',18,'团员','汉族','自动化系');
delete from Students;
BACKUP DATABASE rr TO DISK = 'c:\pp.bak'
use master; restore database rr from disk='c:\pp.bak' with replace;