Click here to monitor SSC

How to open a .Bak file created during SQL Db Backup?

Last post 08-13-2009, 10:40 AM by homebrew. 2 replies.
Sort Posts: Previous Next
  •  04-27-2009, 11:23 PM Post number 73281

    How to open a .Bak file created during SQL Db Backup?

    Hi friends,
    Good morning to all.
    Today i learnt how to take DB backup in to two different Drives.But, i am facing a small prob , the problem is that how to open a .bak file in SQL server and how to read the info present in it?

    Venu Gopal.K
  •  06-12-2009, 10:09 AM Post number 73751 in reply to post number 73281

    • Arles is not online. Last active: 02-23-2011, 7:26 AM Arles
    • Top 25 Contributor
    • Joined on 10-20-2008
    • Nashville, TN
    • Celeron 450

    Re: How to open a .Bak file created during SQL Db Backup?

    If you have a test server available or any other server that’s not the same server as the one you’ve created the backup from, then you should be able to “restore” the backup file on the test server.  Use SQL Server Management Studio to view and open the contents of the newly restored database.  Using another server would prevent you from overwriting your production database, granted that the database does not also exist on the test server.

     

    I hope this information is helpful.

  •  08-13-2009, 10:40 AM Post number 74375 in reply to post number 73281

    Re: How to open a .Bak file created during SQL Db Backup?

    You don't open a .BAK file. You use it to:

    1) Restore on top of your damaged or corrupted database

    2) Restore to another server, for example to developement from production

    3) Restore to the same server, but with a different name, for example to retrieve specific data

    etc ....

View as RSS news feed in XML