HOW TO OPEN A SQL SERVER .BAK FILE (NOT RESTORING!)

Simons Hood

Total Post:70

Points:494
Posted by  Simons Hood
 906  View(s)
Ratings:
Rate this:
I have been reading a LOT of google posts and StackOverflow questions about how to restore a database in SQL Server from a .bak file.

But none of them states how to just READ the tables in the database-backup. (None that I could find anyway?)

I just want to check out some old information which now has been deleted, without actually restoring the full database. Is this possible?
  1. Mayank Tripathi

    Post:397

    Points:3117
    Re: How to open a SQL Server .bak file (Not restoring!)

    From SQL Server 2008 SSMS (SQL Server Management Studio), simply:

    1.Connect to your database instance (for example, "localhost\sqlexpress")
    2.Either:
         a) Select the database you want to restore to; or, alternatively
         b) Just create a new, empty database to restore to.

    3.Right-click, Tasks, Restore, Database

    4.Device, [...], Add, Browse to your .bak file
    5.Select the backup.
    Choose "overwrite=Y" under options.
    Restore the database

    6.It should say "100% complete", and your database should be on-line.

    PS: Again, I emphasize: you can easily do this on a "scratch database" - you do not need to overwrite your current database. But you do need to RESTORE.

    PPS: You can also accomplish the same thing with T-SQL commands, if you wished to script it.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!