Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

I have SQL Server Management Studio. I need to access a backup file (*.bak).

How do I create a new database engine that is OFFLINE (running from my PC not the server) and then restore the database to that offline database engine?

Help will be greatly appreciated.

share|improve this question
Why you want the server to be offline? It can not be offline - it has to process the restore. You mix something up seriously here. It makes no sense for the database engine not to be online. – TomTom Jul 5 '12 at 13:09

migrated from stackoverflow.com Jul 5 '12 at 15:06

3 Answers

up vote 4 down vote
  1. Install SQL Server, if it isn't already there.
  2. Get the backup file onto you local box.
  3. Open SSMS and connect to your local instance
  4. Right-click the "Databases" folder and pick "Restore Database..."
  5. Follow the wizard until you're done
share|improve this answer
How do I check if SQL server is installed I've got: "Microsoft SQL Server 2008 R2" under my programs where I've found SSMS. Sorry for the stupid questions. – wilest Jul 5 '12 at 13:04
4  
Out of curiosity, how could you not know whether or not SQL Server is installed and yet you want to restore a database? – jonnyGold Jul 5 '12 at 13:15
up vote 2 down vote

You will have to do an instance install on your PC. Then with that stand-alone instance you will be able to restore your database in the fashion you want on your isolated environment.

share|improve this answer
Can you elaborate? I have the Management studio software on my pc. – wilest Jul 5 '12 at 12:55
Having SSMS on your PC isn't enough. You need to actually have a SQL Server instance on your machine to do what you want. – Thomas Stringer Jul 5 '12 at 12:56
up vote 1 down vote

I think this is what you want?

To see if you have a local server installed open up an app called "sql server configuration manager"

Under SQL Server Services you should be able to see if anything is running or not.

To Connect to your local instance. (SQL Server Management Studio)

  1. Click on file
  2. Connect object explorer
  3. Under servername type "localhost"

In Object explorer

enter image description here

  1. Right click on the Databases folder underneath the server you want to restore to (your local server in this instance)

  2. New Database, then follow the prompts. (this is the db you'll restore your backup to)

  3. [a] Restore database (select the newly create database,

    [b] and choose from device and select the backup file.

    [c] Under options, choose to overwrite the db) an run the restore

share|improve this answer
Yes almost, except I want an offline database engine – wilest Jul 5 '12 at 13:03
Why offline if i might ask? If its a local instance. Restore then take it offline? – Rohan Büchner Jul 5 '12 at 13:05
Thanks for the screenshots! – wilest Jul 5 '12 at 13:05
I need to compare data between yesterday & today and I don't want to add it on the server, afraid I'll mess something up, so that's why I need it offline. What do you mean by local instance? – wilest Jul 5 '12 at 13:06
To be honest, I've never heard of restoring to an offline instance... by logic it needs to be active for you to interact with it. But what do I know :/ – Rohan Büchner Jul 5 '12 at 13:07
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.