MS Sql Server Local DB
Web.Config file: <add connectionstring="Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=[database-name]; Integrated Security=True" name="ConnectionString" providername="System.Data.SqlClient" /> Connect to Local DB: Open Visual Studio: Menu: Tools > Connect to Server > Left navigation bar > New Data Connection: Server Name: (LocalDb)\MSSqlLocalDB drop database "myDB"; create database "myDB"; -- Check the logical file name (1st column) after running this query RESTORE FILELISTONLY FROM DISK = 'E:\Ismail\Projects\VPT_TVL\vpt\database\VPT.bak'; -- Place the Logical file name after MOVE statement, and a path where database files will be created RESTORE DATABASE "myDB" FROM DISK = 'D:\database\myDB.bak' WITH MOVE 'myDB_Data' TO 'E:\database\TVL_PT_Data.mdf', MOVE 'myDB_Log' TO 'E:\database\TVL_PT_Log.ldf', REPLACE;