Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: Having trouble restoring SQL database - user permissions issue?


    you can ignore this now. I don't know how to delete the thread. maybe a mod can?

    Hi all

    I'm trying to create a new database with an external backup someone created for me.

    I'm using:
    Microsoft SQL Server Management Studio Express v9.0
    SQL server 2005

    And following this tutorial:
    How to backup and restore database on Microsoft SQL Server 2005 | Linglom's Blog

    When i try to specify the backup location, i get the following error:

    Now, i think my SQL service account has access to the path, so it should work, right?

    At a loss for what to do next. Driving me nuts
    Last edited by ThriceAgainst; 12-16-09 at 08:58.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Move the backup file to some other location (say the root of c:\), and see if you can read from the backup file there. Commonly it is a spelling mistake of some sort in the path.

Posting Permissions

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