By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

to read backup file

P: n/a
Hello,
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.

regards
Zenek
May 20 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Zenek (zi*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 20 '06 #2

P: n/a
Erland Sommarskog napisa?(a):
Zenek (zi*****@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
May 21 '06 #3

P: n/a
Zenek (zi*****@op.pl) writes:
of course, but I need to know this value before restore, without server
assist.


Please give a more detailed account of your actual problem. Particularly,
why is it not feasible to restore the backup and read the data?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 21 '06 #4

P: n/a
Erland Sommarskog napisaƂ(a):
Zenek (zi*****@op.pl) writes:
of course, but I need to know this value before restore, without server
assist.


Please give a more detailed account of your actual problem. Particularly,
why is it not feasible to restore the backup and read the data?

because I have my small program for several database's operations and I
want fast to view, fast to know versions of backups (to read value of
one field), I want not to use server or some libraries, I want to use
f.e. in C fopen function and by fseek to get to needed information.
May 21 '06 #5

P: n/a
Zenek (zi*****@op.pl) writes:
because I have my small program for several database's operations and I
want fast to view, fast to know versions of backups (to read value of
one field), I want not to use server or some libraries, I want to use
f.e. in C fopen function and by fseek to get to needed information.


No, you don't want to that. The backup format is to my knowledge not
publicly documented.

If the databases are as small as you have indicated, there is little
loss in execution time in actually restoring the databases and reading
the value in the regular way.

And you did not really answer my question. That is, there must be some
real-world problem you are trying to solve. What does this value you want
to read represent?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 21 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.