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

Posted on

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.

Leave a Reply

Your email address will not be published. Required fields are marked *