Query

[David Parkes]

Hi everyone,

We have a *.BAK file and inside it is some useful data. We do not know what
program was used to produce this file all we know is it is a backup of an
SQL database. Is there anyway we can extract the data which it contains
without knowing the program used to create it?

 

[gerryR]

in general a .bak file is can just be renamed with the extension of the file
that it came from.

eg autocad .dwg creates backup files .bak. To use them you just rename .bak
to .dwg. Should be the same for you although I'm not 100% sure.

hth
gr



"David Parkes" <wibble@wobble.com> wrote in message
news:eFmSe72zHHA.484@TK2MSFTNGP06.phx.gbl...
> Hi everyone,
>
> We have a *.BAK file and inside it is some useful data. We do not know
> what program was used to produce this file all we know is it is a backup
> of an SQL database. Is there anyway we can extract the data which it
> contains without knowing the program used to create it?
>

 

[David Parkes]

Thanks for the insight. I wouldn't have thought that.

"gerryR" <gerryrNO@SPAMgerryr.com> wrote in message
news:ebivN%232zHHA.2312@TK2MSFTNGP05.phx.gbl...
> in general a .bak file is can just be renamed with the extension of the
> file that it came from.
>
> eg autocad .dwg creates backup files .bak. To use them you just rename
> .bak to .dwg. Should be the same for you although I'm not 100% sure.
>
> hth
> gr
>
>
>
> "David Parkes" <wibble@wobble.com> wrote in message
> news:eFmSe72zHHA.484@TK2MSFTNGP06.phx.gbl...
>> Hi everyone,
>>
>> We have a *.BAK file and inside it is some useful data. We do not know
>> what program was used to produce this file all we know is it is a backup
>> of an SQL database. Is there anyway we can extract the data which it
>> contains without knowing the program used to create it?
>>
>
>

 

[WorkingHard]

If it's an SQL server backup you can restore it to SQL Server. Renaming will
not work. SQL Server allows you to read the content description from the
bakup file as well. Renaming only works with file copies that just cot a
..BAK extention. Do not assume all bak files are just that.

Cheers


"David Parkes" <wibble@wobble.com> wrote in message
news:eFmSe72zHHA.484@TK2MSFTNGP06.phx.gbl...
> Hi everyone,
>
> We have a *.BAK file and inside it is some useful data. We do not know
> what program was used to produce this file all we know is it is a backup
> of an SQL database. Is there anyway we can extract the data which it
> contains without knowing the program used to create it?
>