Error when trying to restore SQL Server database backup file
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 14, 2008 2:55 AM
UPDATED:
August 10, 2010 3:59 PM
RELATED QUESTIONS
- How do you restore and recover RMAN incremental backup on a new Host in different HDD partition?
- Restore SharePoint 2003 database/s on SQL Server 2005
- Recovering lost data from SQL Server 2005
- Microsoft Sequel Server 2005 VSS backup
- Error in SAP after migration of OS & Filesystem data from one hardware to other hardware
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
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.
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