CODEWITHSUNDEEP
sql-server-2008-r2sql-server-2014restore
OTUser
OTUser

Reputation: 3848

How to restore backup from SQL Server 2008 R2 in SQL Server 2014?

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?

Upvotes: 0

Views: 110

Answers (1)

woody2k
woody2k

Reputation: 76

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.

Upvotes: 1

Related Questions