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?

  • 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

  • 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.

  • 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?

    ---------------------------------------------------------------------

  • 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]

  • 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


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • 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

  • 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

  • This is only possible by using some specialized tool. Read more here

  • 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