Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 sql server file error

Author  Topic 

walbornkeeg
Starting Member

1 Post

Posted - 2015-02-22 : 11:04:48
I made backup of database and I receive file .bak.

Now I want restore the database in my machine. But I get the following error: "Cannot open backup device 'C:\Program Files...\MSSQL10_50.SQLEXPRESS...\file.bak'.".

How to solve this issue?

great thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-22 : 15:18:35
Please show us the full error.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2015-02-23 : 23:49:20
It might possible that Backup has some problem.

RESTORE VERIFYONLY is a good option to check SQL database backup after the backup has completed. It checks the backup to ensure it is complete and the entire backup is readable. The does not do an actual restore, but reads through the file to ensure that SQL Server can read it in the event that a restore using this backup needs to occur.
Go to Top of Page

daghansabanci
Starting Member

1 Post

Posted - 2015-03-02 : 12:32:40
Hi,

I visited a lot of forums and communities, but this one:-

http://answers.unity3d.com/questions/738158/how-to-repair-backup-of-mdf-file-database.html - gave me one of the best tips I've seen.

This forum is non commercial and any user can help you. See it, if you have time.

Thanks.
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2015-05-28 : 00:51:21
Personally, I know this error happens when
1. There is no directory with Log
2. There is not enough space on drive d:3. There is not enough permissions on d:\Log drive
But actually The error was there because of the file was read only. May be there was already another backup file which existed in the folder with the same name and it was marked as read only. Due to the same reason, my backup was failing. Once I removed the checkbox for reading only, the backup was successful.

Go to Top of Page
   

- Advertisement -