SQL SERVER_Restore(version)

Background:

We have a project use SQL SERVER 2012. When I tried to restore a backup into my local database, it failed with error report:  “media family”. Check on the internet, it maybe because the backup file has the different SQL Server version with my local database, and I can use that script to find out the version of current database:

select @@version

 

1)      The source version :

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2)      The target version:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Hence, I need to install a 2012 express on my local pc.

When installing a new 2012 SQL Server faced with error and failed to start the new created database: LOCALHOST_2012. Check from stackoverflow, showed I need to change the Account Name of Database Engine Service to NT AUTHORITY\NETWORK SERVICE, then successfully create new server with 2O12 version: LOCALHOST_12.

 

After all, I tried to restore backup into my new SQL Server: LOCALHOST_12, unfortunately error again, seems like if it’s the first time I try to restore a backup in a new created database I need the Tail-Log backup file. But I don’t have one! So just click the Options and don’t click the Tail-Log backup option and restore. Finally, we restore the backup successfully! Wow!