Announcement

Collapse
No announcement yet.

Can I move a SQL database from MS SQL 2008 r2 web edition to MS SQL Express Edition?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can I move a SQL database from MS SQL 2008 r2 web edition to MS SQL Express Edition?

    I have a dedicated server running MS SQL 2008 r2 for my business website.
    I want to set up a backup system in a lesser spec environment that have MSSQL Express.
    I keep trying backing up the 2008 r2 databases and returning them on SQL Express, but get various errors. It would be great if someone help me out to resolve these errors.

  • #2
    what are the errors?

    Comment


    • #3
      I am getting the following error:

      "Specified cast is not valid"

      The SQL version creating the backup is 11.0.5343.

      The SQL version I am restoring on to is 10.50.4042

      Comment


      • #4
        The problem is you can't go back to a previous version and your SQL server where you have to return it must be at minimum 11.0.5343 but that can’t be a problem as SQL Express is free thus go and download SQL 2012 express I think it should work for you.

        Here are the build/version numbers association
        https://buildnumbers.wordpress.com/sqlserver/

        sql 2012 express dwonload link and put SP2 on the top - that will be sufficient to acquire the databases restored
        https://www.microsoft.com/en-ca/down....aspx?id=29062

        Comment


        • #5
          Thanks, I'll try this one

          Comment

          Working...
          X