You are here: Re: to read backup file « MsSQL Server « IT news, forums, messages
Re: to read backup file

Posted by Zenek on 05/21/06 01:27

Erland Sommarskog napisa?(a):
> Zenek (zingiel@op.pl) writes:
>> I have:
>> - server MS SQL MSDE (2000)
>> - database 'COLLBASE'
>> - table 'MAIN'
>> - row: column 'NAME' value 'version' and column 'VALUE' value '003'
>>
>> I make backup files by SQL query.
>> I have more backups for different versions of this database (different
>> value in field 'VALUE' in table 'MAIN').
>>
>> I would like to read this value from backup file without server assist,
>> to get backup as ordinary file.
>> How to do it?
>> How to move in this file?
>> What is physical structure of backup file?
>>
>> I can't to read this file from begin by compare strings, because these
>> files are very large, few 100MB.
>
> What are you really trying to achieve? The normal way to read data from
> a backup is to restore it into a database. And if the database is just a
> mere couple of 100 MB, that's a fairly snap operation.
>
>
of course, but I need to know this value before restore, without server
assist.

Regards,
Zenek

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация