有些SQL Server的相关文件,怀疑是导入用的数据或是配置文件,但这些文件没有后缀,所以无法区别,请问有何方法可以知道这些是什么文件?(100分)

  • 主题发起人 主题发起人 powerv
  • 开始时间 开始时间
P

powerv

Unregistered / Unconfirmed
GUEST, unregistred user!
有些SQL Server的相关文件,怀疑是导入用的数据或是配置文件,但这些文件没有后缀,所以无法区别,请问有何方法可以知道这些是什么文件?
这些文件有几个特征:
1、没有后缀名;
2、文件名有其它文件名称;
3、是二进制文件,可以UE查看内容;
4、文件头内容的前四个字母为TAPE
 
下面是我的SQL Server数据库备份文件的文件头信息:
偏移量: 00000000
54 41 50 45 00 00 03 00 8C 00 0E 01 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
02 00 87 05 A7 D7 49 AB 01 00 00 00 01 00 00 00
01 00 01 00 00 00 00 00 00 00 00 00 00 00 00 00
2C 00 5E 00 00 04 00 12 1F 4C C7 05 D1 01 4D 00
69 00 63 00 72 00 6F 00 73 00 6F 00 66 00 74 00
20 00 53 00 51 00 4C 00 20 00 53 00 65 00 72 00
76 00 65 00 72 00 00 00 00 00 00 00 53 50 41 44
对应的文本为: TAPE... M.i.c.r.o.s.o.f.t. .S.Q.L..S.e.r.v.e.r... SPAD
偏移量: 00000600
53 53 45 54 00 00 00 00 9C 00 0E 01 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 15 00 64 00
02 00 F7 06 04 00 00 00 00 00 00 00 00 12 01 00
1C 00 7A 00 00 00 00 00 00 00 00 00 04 00 96 00
00 06 00 00 00 00 00 00 1F 4C C7 5D 32 08 00 20
00 02 00 00 8A 11 F4 CE 5C 8D FF 4A 8E 54 BA 3C
DC 50 76 15 00 00 00 00 00 00 44 00 61 00 74 00
61 00 43 00 6F 00 6C 00 6C 00 65 00 63 00 74 00
20 00 07 59 FD 4E 73 00 61 00 00 00 53 50 41 44
00 00 00 00 4E 03 00 00 00 00 00 00 00 00 00 00
5C 17 00 00 00 00 00 00 00 00 00 00 00 00 00 00
对应的文本为: SSET... D.a.t.a.C.o.l.l.e.c.t... SPAD
(注:DataCollect是备份的数据库名称)
在SQL Server中还原数据库即可。
 
Restore fileonly from disk =''
就可以看看你说的这些文件内容了!
 
多人接受答案了。
 
后退
顶部