Friday, March 23, 2012

Read MS SQL 2000 backup file without restoring the database

I want to read certain data from the backup file of MS SQL 2000 without restoring the database backup file. Based on the data selected I will manage the further functionality such as restoration of the backup file.
Is it possible to read some data from MS SQL 2000 backup file without restoring? If yes then please let me know how?
I don't think you can read the data without restoring the backup file...................also you need to restore the entire backup file and after restoring it you can choose the data you need..........may be if you already have a db take a backup before restoring from the backup (overwrite) and then choose your data and if needed you can export it and then once again restore the original backup of the db...........|||

Just to be clear, you definitely can't directly read from a backup file.

|||hmmmm.....Ok, is it possible that I can restore only one table from my MS SQL backup file to some other temp db? Which will help me to get the required value from that table.
|||you can restore your backup file as a entire db and then export the required table to another db in the same server or in another server ...
|||

No - you can only restore a complete database. Restoring a single table is a commonly requested feature - it's not included in SQL Server 2008 but may make it into the following version.

Thanks

sql

No comments:

Post a Comment