SQL file problem?

[rninja]

I have a problem here. I received a file from a client and it seems to be their database, but the file is full of garbage. Can anyone identify this and/or tell me what I can do with it? I will not post the whole thing here since it is over 4MB of text data and the data is sensitive but here is the header for identification:

FFFfg`
@
P
0



àð°ÀÐ P`p€?àÐÀ°p€? °ÀÐàð 0@@0 ðàÐÀ°P`p€? °ÀÐàð 0@Pp€? 0@P`ð ÀÐàp€? ° 0@P`À°ðÐàp€ ?0@`P ÀÐðàP`°p€? àð@ 0p`Р°À€?0@P ðàÐÀ°`p€?  À
?°
€ 
p?
`€
Pp
@`
0P
@
0

ð
à
Ðð Àà °Ð  À ?° €  p? `€ Pp @` 0P @ 0  ð à ÐðÀà°ÐÀ°P @?0€p`?
@€
0p
`
P
@
0
ð

à


Ð
ð
À
°
à
Ð
 
ÐÀ ° ð?à€ðpàÐ`PÀ@°0  ?ЀÀp°` P?@€p0`P@ 0 ððàÐÀ°à€ ?p?
€
p
`
`PP
@
@0

0

ð àÐð
À° à
?Ð
€À
p°
` 

Zø:

¨
^
9
8W!À`

5
=
X
p;
F0


?(convert(smallint,0))0

!(8000)i0

½(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)ÿ0

³(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or (type_name([xtype]) = 'char' or type_name([xtype]) = 'binary')) and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))0

?(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))0

?(convert(smallint,columnproperty([id],[name],'oldusertype')))0

W(convert(varchar(255),[autoval]))0

û
(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))!0

O(odbcscale([xtype],[xscale]))0

](convert(int,sign(([colstat] & 4))))0

](convert(int,sign(([colstat] & 4))))0

_(convert(int,(1 - ([typestat] & 1))))0

•(convert(sysname,collationpropertyfromid([collationid],'name')))­0

©(convert(binary(5),collationpropertyfromid([collationid],'tdscollation')))0


?(convert(smallint,typeproperty([name],'oldusertype')))LW!0

A
(convert(bit,case when ((type_name([xtype]) = 'nvarchar' or (type_name([xtype]) = 'varchar' or type_name([xtype]) = 'varbinary'))) then 1 else 0 end))0

[(convert(bit,(1 - ([status] & 1))))0

e(convert(tinyint,xtypetotds([xtype],0)))u0

M(convert(varchar(255),null))0


(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null else (typeproperty([name],'precision')) end))0

s(convert(tinyint,typeproperty([name],'scale')))0

•(convert(sysname,collationpropertyfromid([collationid],'name')))0

m(convert(smallint,(2 + 4 * ([status] & 1))))
0

?(convert(smallint,0))0

O(convert(bit,([status] & 1)))0

O(convert(bit,([status] & 2)))!0


Ù(convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))u0

?(convert(smallint,0))0

?(convert(smallint,0))0

O(convert(bit,([status] & 2)))0


O(convert(bit,([status] & 4)))0


O(convert(bit,([status] & 8)))0

?(convert(smallint,0))0

?(convert(smallint,0))0


¹(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))VW!0


¹(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))0

¹(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))WW!0


¹(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))0

¹(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))YW!0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))!0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0

»(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))h
8
8
?_W!(0
h_W!@_W!дø<€ÄL?Ô\ ä¤dÄt4ôÈx8È0¼<ì„(ä`´

¼
\
ü ¬ °XÈ8„
Ä `

-
.J
9–<
•0. ¥¥ 
úÿ
úÿ 

Crefmod0.
4
4

 

=uid¥0.
4
4 

Cstatus0.
ç


ÿÿÿÿÐ4 
?name0.
¥¥Uþÿþÿ 

=sidaV!0.
¥
¥ýÿýÿ 

Aroles0.
=
= 

Kcreatedate0.
=
= 

Kupdatedate0.
4
4 

Caltuid0.
¥¥
üÿ üÿ 

Gpassword0.
8
8


 

;id0.
4
4 

EsmallidjV!0.
0
0

 

?type0.
ç


ÿÿÿÿÐ4 
?name0.
bbPþÿþÿ 

Avalue0.8
8


<

;id0.8
8
<

Adepidg0.4
4
<

Cnumber0.4
4<

Idepnumbert0.4
4<

Cstatus0.0
0
<

Edeptype0.44


Edepdbid0.44


Idepsiteid0.hh




Cselall0.hh



Thanks! I appreciate any help available in solving this matter.

Rninja

http://www.rninja.com

 

[hmckillop]

Have you tried restoring the file to a database, or creating a database of the same name and attaching the file?


"I'm living so far beyond my income that we may almost be said to be living apart