snippetsqlMinor
Jetbrains 0xDBE : How can I load a SQL Server .bak file?
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
Depending on where the backup came from, you will likely need to use the
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.