Wednesday, March 21, 2012

Restore SQL database

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.googlegroups.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