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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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. |
|
|
|
daghansabanci
Starting Member
1 Post |
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2015-05-28 : 00:51:21
|
| Personally, I know this error happens when1. There is no directory with Log2. There is not enough space on drive d:3. There is not enough permissions on d:\Log driveBut 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. |
|
|
|
|
|
|
sql server file error