HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Jetbrains 0xDBE : How can I load a SQL Server .bak file?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
can0xdbefilehowsqljetbrainsloadserverbak

Problem

I'm trying this new Jetbrains IDE and I can't figure out how to load a SQL Server 2008 R2 .bak file. Maybe I'm looking in the wrong menus. Is it possible?

Solution

An IDE is not going to be able to "load" a SQL Server backup. You need to restore the backup to a running instance of SQL Server, then the IDE will be able to connect to it and interact with it. You should be able to connect the IDE to a running instance of SQL Server, and then through a query window run a RESTORE command, documented here:

  • RESTORE (MSDN)



Depending on where the backup came from, you will likely need to use the WITH MOVE options, as it is unlikely your default data/log folders match those from the source.

Context

StackExchange Database Administrators Q#122843, answer score: 6

Revisions (0)

No revisions yet.