September 6, 2007 at 3:21 am
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?
September 6, 2007 at 9:26 am
Unless the backup file is encrypted, you can open it with Notepad. It's unstructured and a lot of stuff is unreadable, but there's some plain text in there. The contents make a lot more sense if you restore the backup to a new database and look at the tables, etc.
Also, the Log reader applications from Redgate, Lumigent, et al can read a transaction log backup.
Greg
Greg
September 7, 2007 at 1:10 am
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.
September 7, 2007 at 3:39 am
Kedar,
there is no sql native command to restore just one table or any other object from a SQL full backup, so what you require is not possible............unless anyone out there knows a third party tool that can do it?
---------------------------------------------------------------------
September 7, 2007 at 4:35 am
BMC offers a backup solution which supports object-level restore. Can't say I have any real world experience with it, but I tested it some time ago and it looked fine.
But it's not an option for the current situation here, since the object-level restore works not for backups taken with the standard SQL backup.
If anyones interested look here:
http://www.bmc.com/products/proddocview/0,2832,19052_19429_70025639_147752,00.html
Markus
[font="Verdana"]Markus Bohse[/font]
September 7, 2007 at 5:17 am
Have a look at Red Gate's SQL Data Compare 6 (alpha). While it says it is an alpha version, it is very stable. It can read backup files, and show its contents.
http://www.red-gate.com/messageboard/viewtopic.php?t=5377
Disclaimer: I work for RG.
Andras
September 7, 2007 at 5:51 am
Idera's SQLsafe backup software now has a version 4.5 that enables recovery of individual tables. I am currently on 4.0, just haven't had the time to upgrade, but wanted to make you aware of it.
Joe
September 7, 2007 at 11:48 am
Kedar,
Although there isn't a native SQL Server object restore, you can restore a database backup to a new database using the 'WITH MOVE' option of the RESTORE DATABASE command. Then, you can copy the table back into the original database.
Greg
Greg
July 8, 2013 at 1:04 am
note: 6 year old thread
---------------------------------------------------------------------
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply