Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Devic
e
activation error. The physical filename...maybe incorrect. File...cannot b
e
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the consol
e
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root.
Are you saying that the restore executed without error message but you didn'
t see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the da
tabase.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Dev
ice
> activation error. The physical filename...maybe incorrect. File...cannot
be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:

> Are you saying that the restore executed without error message but you did
n't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the
database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>