sql server data warehouse: I have to recover a database and redirect it to another
server with the same database name. Every time I run the
job, I get "Unable to attach to <servername>.
A network connection to the device could not be
established."
What am I missing? How can I redirect a SQL restore to

Are you backing up and then trying to attach the database? This will not
work as the MDF is locked while the sql service is running. Trying backing
up the one database and restoring (not attaching) the .bak file that was
generated when you backed it up. See restore in BOL for more details.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

Try the other direction - issue the restore on the machine local to where
you want it to land and tell restore the network location of the file(s) for
recovery. All the usual rules regarding sql service account network access
also apply.



--
Kevin Connell, MCDBA
--------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
[quoted text, click to view]