Question :
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?
Answer :
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:
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.