0

I'm uploading a .bak file I created on my hosting server, the hosting provider is using SQL Server 2014 or 2016 version. I download the file, but can't open in my SQL Server 2008. I got a message :

TITLE: Microsoft SQL Server Management Studio

Specified cast is not valid. (SqlManagerUI)

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
samuel henk
  • 13
  • 5
  • easiest solution is to use same or higher version of SQL Server. If your DB size is not huge, you can use SQL Server Express edition or SQL Server 2016 Developer. Both are free – Squirrel Nov 20 '17 at 04:00
  • so i must buy sql server 2015 version.. its hard hehehe – samuel henk Nov 20 '17 at 04:07
  • yes. it is hard to buy `SQL Server 2015`, as it is not exist. If you using it for development, you can use 2016 / 2017 developer edition, it is free :) – Squirrel Nov 20 '17 at 04:39

1 Answers1

1

I think You won't be able to do this. Upper version bak file can't be restored to lower version. The better option is to generate script of that database from 2008 R2 and run it to your desired version of sql server.

Newaz Sharif
  • 424
  • 4
  • 12