How to open a SQL Server .bak file (Not restoring!)

Anonymous User 2405 05 Sep 2015

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 Answers

Anonymous User 05 Sep 2015

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.

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to open a SQL Server .bak file (Not restoring!)

Can you answer this question?

1 Answers