Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015
    Posts
    2

    Unanswered: How to restore my sql server database to my pc?

    Dear all,

    I lost my database on my pc as I format my hard drive. Now could anyone guide me how I can get a copy of my ms sql server database from my hosting to work with my local pc? I need to have a local copy so that I can develop my site without internet connection. For your information, I'm using Hostforlife.eu hosting service. I have searched and tried many methods to do it, but no luck yet. For example, I created a backup on Hostforlife.eu and restore backup file on my pc, but nothing happens. Then I created a new database, and re-created its structure same as the one on Hostforlife, then I used the import wizard to import data from them to my pc. Again, nothing happens.

    I hope someone can give me a way of getting back my database to my pc as it's really frustrated if I don't have my database run locally on my pc. Thank you so much in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Without more information about your problem I can't be certain about my answer, but I think that I understand your problem.

    HostForLife.EU normally uses SQL Server 2014.

    You can't restore a backup to an older version of Microsoft SQL Server. If your backup was created by SQL 2014, then your restore machine (your desktop) has to be SQL 2014 or later.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •