|
|
Posted by Erland Sommarskog on 05/20/06 18:54
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.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|