How to do database restoration??

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
another server? Thanks!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
--
"Brandon" <anonymous@.discussions.microsoft.com> wrote in message
news:076d01c3ca2c$f344f3e0$a501280a@.phx.gbl...

quote:

---

> 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
> another server? Thanks!

---

|||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.
----
"Brandon" <anonymous@.discussions.microsoft.com> wrote in message
news:076d01c3ca2c$f344f3e0$a501280a@.phx.gbl...

quote:

---

> 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
> another server? Thanks!

---