Error when trying to restore SQL Server database backup file

Tags:
SQL Server backup and restore
SQL Server errors
We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we have no access to the file 'C:Program FilesMS SQL Server.....'. Also we are unable to access it from some other path.
ASKED: May 14, 2008  2:55 AM
UPDATED: August 10, 2010  3:59 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will need to make sure that the Windows account which the SQL Server service is running under has full control to the folder which has the backup file as well as the file, as well as the folder which you want to restore the database to.

You may also need to go to the second tab of the restore window and change the paths to the database files. You can also use the RESTORE DATABASE command manually to restore the database using the WITH MOVE option to specify where you want to restore the database to.

If you are still getting the error message please post the entire error message. Without the full error message I’m just guessing here.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    65,490 pointsBadges:
    report
  • carlosdl
    It seems that AlexKrenvalk has had all sorts of problems, and he has been lucky enough to solve them all with the help of tools from the same site. This is advertising.
    65,110 pointsBadges:
    report
  • MelanieYarbrough
    Thanks, Carlos. We're always on the lookout for advertising and spammy posts, but sometimes they get away from us. I've removed his comments and blocked him from the site. Thanks for the heads up! Melanie
    6,345 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following