Post reply

Interogating .BAK files

  • December 5, 2005 at 7:09 am

    #110400

    Hi all,

    Do any of you know of any tools that allow you to interogate .bak files and extract mdf/ldf files from them?

     

    Many thanks,

    Iain Wilson

  • December 5, 2005 at 8:43 am

    #607723

    If you have taken the back-up using T-SQL, you can use the RESTORE command options "RESTORE FILELISTONLY", "HEADERONLY" or "LABELONLY" to get more information on the back-up file.  Look up BOL for more information on these.

  • December 5, 2005 at 9:54 am

    #607736

    Quest has a product called LiteSpeed that lets you perform object recovery on native and compressed backup files.  This tool allows you to extract individual tables (data and/or schema), stored procedures, views, functions, UDT's, etc... from a full backup file.  More information can be found at http://www.quest.com/news/show.aspx?ContentID=2539&ContentTypeID=2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply