Post reply

Query a backup file?

  • October 4, 2005 at 2:10 pm

    #110613

    Please forgive what I am sure will sound like a really stupid question to all of you... I need to query a DB for some information, but the DB owner will not give me access. Instead he sent me a backup file (looks like a dump) from MS SQL Server DB

    I'm not a DBA--just a regular person with general SQL and Perl skills. Is it possible for me to query this file? If so, can someone just point me to whatever app I need to download to do this? If not, any suggestions?

    Thanks!

  • October 4, 2005 at 2:12 pm

    #594987

    Restore the file to another server and then you'll be able to query it. Check out BOLS for the syntax.

  • October 4, 2005 at 4:46 pm

    #595031

    Resolved.

    Thanks for pointing me in the right direction. I downloaded trial version of Server and was able to upload the backup and perform my queries.

    Cheers,  Lisa

  • October 5, 2005 at 12:59 pm

    #595240

    Lisa,

    You can ask the dba to give you read access, can't imagine you having to do this task everytime you want to query this db especially if you want refreshed data.

    Jules

    Jules Bui
    IT Operations DBA
    Backup and Restore Administrator

  • October 7, 2005 at 9:41 am

    #595918

    YOu can have your DBA run a DTS package that can update the information in the database that your restored from his backup file.  He can create a linked server to your database and the run the package each night at midnight and update the information in you database and then you won't access his database.  You could also learn more SQL in the process working with your own database.

    Rob Broyles

Viewing 5 posts - 1 through 4 (of 4 total)

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