I have SQL Server Management Studio. I need to access a backup file (
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?
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 only takes a minute to sign up.Sign up to join this community
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)
In Object explorer
Right click on the Databases folder underneath the server you want to restore to (your local server in this instance)
New Database, then follow the prompts. (this is the db you'll restore your backup to)
[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