sqlserver2000backup.txt

来自「实现JSP开发的BBS源码」· 文本 代码 · 共 61 行

1.创建数据库

create database test_DB;


2.修改数据库属性


3.安全备份数据库

backup database test_DB to disk='d:\test_DB.bak' with init;

4.切换到test_DB,创建表test_TB

create table test_TB(
                     name char(10)
                    ,tel  char(11)
);

5.向表中每隔一分中加入一个记录

insert into test_TB values('余克朝','15955016817');

insert into test_TB values('石怀飞','15955016993');

insert into test_TB values('王友志','15955016807');

insert into test_TB values('李辉辉','13866522901');

insert into test_TB values('黄  康','13615502197');

insert into test_TB values('孙修文','15955016992');

6.查看结果

select * from test_TB;

7.删除一条记录

delete from test_TB where tel='15955016807';

8.备份日志

backup log test_DB to disk='d:\DB\test_DB.logs' with init;

9.退test_DB,做数据库完全恢复

restore database test_DB from disk='d:\test_DB.bak' with norecovery

10.回到test_DB,查看结果

select * from test_TB;

11.用日志恢复到时间点
restore log test_DB from disk='d:\DB\test_DB.logs' with recovery ,stopat='12/10/2007 23:58';

12.查看结果

select * from test_TB

13.成功恢复