I'm attempting to restore a backup of a database as another database -
so I can access the data in the backup file and transfer some of it to
the existing (operational) database.
However, when doing this, I get the following error:
"Cannot open backup device 'x:\file path on server'. Device error or
device off-line. RESTORE DATABASE is terminating abnormally."
This is the second time this has happened, despite the fact that the
backup device is on-line.
Yet I was able to perform the same operation a couple of days ago! Any
ideas?
Is the path a local path or a remote path? Is there any chance that another process might be using
that file (AV software, or SQL Server itself currently writing or reading that backup file)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"pinhead" <dlynes2005@.gmail.com> wrote in message
news:1144142488.550473.84590@.j33g2000cwa.googlegro ups.com...
> I'm attempting to restore a backup of a database as another database -
> so I can access the data in the backup file and transfer some of it to
> the existing (operational) database.
> However, when doing this, I get the following error:
> "Cannot open backup device 'x:\file path on server'. Device error or
> device off-line. RESTORE DATABASE is terminating abnormally."
> This is the second time this has happened, despite the fact that the
> backup device is on-line.
> Yet I was able to perform the same operation a couple of days ago! Any
> ideas?
>
No comments:
Post a Comment