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 |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
 Posted - 2007-10-19 : 06:52:02
|
| When trying to restore a database backup using EM, the only device available (in the drive box) to be restored from is the C: drive of the server. There is another drive defined on this server (E:) which contains other working databases, which we have managed to select data from.We also can't create new (more) databases on this (E) drive, and when restoring the same database using TSQL code, we get the following error."Cannot open backup device 'E:\RISK.BAK'. Device error or device off-line. See the SQL Server error log for more details." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-19 : 07:11:10
|
| What's the sql server service account and does it have permission on the drive?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-10-19 : 09:37:44
|
| Good answer - Short, sweet and direct.The admins had "changed" the protections on the server drives...to solve a different problem."Life's a Grand National - clear one fence and another monster is in front of you again." |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-19 : 09:58:27
|
| Good job SQL Service didn't restart in the intervening interval then! |
|
|
|
|
|
|
Drive not available to restore from.