Nowadays each company is in race of making their organization successful. For this many of the biggest organizations keep on releasing the new enhanced versions of their software. To keep their software updated and mapped with the latest technologies prevailing in market each IT industry migrating from old to latest ones.
While migrating towards latest technologies people confronted problems. Here in this article I will provide the solution of one such type of migration problem and that is “How to restore the SQL Server 2008 R2 Database to SQL Server 2014”.
Listed below are the steps need to be followed in order to restore the back up of SQL Server 2008 R2 to SQL Server 2014.
Stop the SQL Server (MSSQLSERVER) service running for 2008 R2
The following screenshot depict the service which is running for SQL Server 2008. We need to stop this service in order to copy the mdf and ldf files of database whose backup we need to restore to SQL Server 2014.
Copy the DB files exists at Path
Copy the mdf and ldf files of database whose back up you need to restore in 2014. You can find these DB files at path -
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
Paste the DB files now in SQL Server 2014 folder
Select the Path: C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA
and paste the copied DB files here in that folder.
Connect to the SQL Server 2014 with SQL Server Authentication mode.
Open the SQL Server 2014 instance and select SQL Server Authentication mode. Enter the details in Login and Password fields.
Once you entered the required fields, you would be connected to the SQL 2014.
Attach the mdf file: Once connected to the SQL 2014, right click on “Databases” and then click “Attach”.
Click on “Add” button and select the folder where we copied the mdf and ldf files.
Select the mdf file.
When you add the mdf file, SQL display both files like mentioned below.
Click “OK”.
After clicking on “OK” button , the DB will be attached to the SQL 2014.