0

I took a backup of a database in SQL Server 2008 R2 via SSMS backup utility and restored the same backup in SQL Server 2014 via SSMS backup utility and the database restore. It was successful but am not seeing any tables in SQL Server 2014 after restoring the database. Can someone help me to restore the SQL Server 2008 R2 database backup (.bak) in 2014?

marc_s
759k185 gold badges1.4k silver badges1.5k bronze badges
asked Mar 13, 2017 at 17:44
4
  • This should be a no-brainer and should just work just fine. Did you refresh the Object Explorer in SQL Server 2014 after the restore? Commented Mar 13, 2017 at 19:31
  • yes I did refresh after the restore Commented Mar 13, 2017 at 21:42
  • Connect to the database and run select * from sys.tables. What do you see? Commented Mar 17, 2017 at 7:59
  • Also run this: SELECT compatibility_level FROM sys.databases WHERE name = 'YourDB'; Commented Mar 17, 2017 at 8:00

1 Answer 1

1

The sql 2008 r2 database backup file should be completely compatible on sql 2014. you can try to restore the database on sql 2008 r2 at first, and check if the table was deleted before the backing up.

answered Mar 17, 2017 at 6:58

Comments

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.