Post reply

Can not restore a backup file

  • July 27, 2012 at 12:56 pm

    #259926

    Hi,

    I generated the database backup in production , copied that backup file (copy/paste) in a network drive and from there copied it to the C drive in the test SQL Server.

    Now, I am trying to restore this .bak file from the Task-->Restore.

    I select from device and give the drive C:\ZZZ

    and the backup file name.

    I am getting this error->

    DB engine could not resolve the specified file location. either the location does not exist or login account does not have access to it.

    My windows network id is the sysadmin on the SQL Server.

    What else do I need to restore the DB?

    Thanks!

  • July 27, 2012 at 1:01 pm

    #1518706

    Looks like a permissions issue, SQL Server can't read from the directory of C:\ZZZ.

  • July 27, 2012 at 1:19 pm

    #1518718

    Lynn Pettis (7/27/2012)

    Looks like a permissions issue, SQL Server can't read from the directory of C:\ZZZ.

    So where shall I put the backup file?

  • July 27, 2012 at 1:23 pm

    #1518722

    SJanki (7/27/2012)

    Lynn Pettis (7/27/2012)

    Looks like a permissions issue, SQL Server can't read from the directory of C:\ZZZ.

    So where shall I put the backup file?

    I copied the file here-->

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.RAPID\MSSQL\Backup

    still the same error.

  • July 27, 2012 at 1:26 pm

    #1518723

    Could be permissions on the file itself. Hard to tell from here.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply