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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 sql server file error
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

walbornkeeg
Starting Member

1 Posts

Posted - 02/22/2015 :  11:04:48  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 02/22/2015 :  15:18:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
212 Posts

Posted - 02/23/2015 :  23:49:20  Show Profile  Visit prett's Homepage  Reply with Quote
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 Posts

Posted - 03/02/2015 :  12:32:40  Show Profile  Reply with Quote
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 - 05/28/2015 :  00:51:21  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000