Local DB.md

Restoring a database to LocalDB

from: http://www.alteridem.net/2016/03/24/restore-a-sql-server-backup-to-localdb/

1. Visual Studio
2. SQL Server Object Explorer (Ctrl+S, Ctrl+)
3. Master => New Query

  RESTORE FILELISTONLY
  FROM DISK = 'C:\Temp\database.bak'

5. Note the names in the 'Logical Names' column from the result
6. Restore the backup

  RESTORE DATABASE Database
  FROM DISK = 'C:\Temp\database.bak'

  WITH MOVE '<data_logical_name_from_the_reults_above>' TO 'C:\Users\admin\database.mdf',
  MOVE '<log_logical_name_from_the_reults_above>' TO 'C:\Users\admin\database.ldf',
  REPLACE;