patternsqlMinor
Restore a SQL Server database to an offline copy
Viewed 0 times
sqlofflinedatabaseserverrestorecopy
Problem
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?
*.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?
Solution
- Install SQL Server, if it isn't already there.
- Get the backup file onto you local box.
- Open SSMS and connect to your local instance
- Right-click the "Databases" folder and pick "Restore Database..."
- Follow the wizard until you're done
Context
StackExchange Database Administrators Q#20433, answer score: 4
Revisions (0)
No revisions yet.