Home > Archive > microsoft.public.sqlserver.server > November 2002 > Restore problem





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Restore problem
Shailesh

2002-11-21, 8:23 am

Dear Friends

I amd getting the following error attached herewith in
word file.

The reason behind this is I have two servers for SQL 2000
and i want to restore the backup of one server ServA to
another server ServB but the problem is i have my data
files on ServA on D: which is hard drive and Now when i
am trying to restore it The D: on ServB is CD drive.\

Please guide me through so that i can solve the problem.

Thanks and best regards
Shailesh Gothal
Tibor Karaszi

2002-11-21, 9:23 am

Go to the right tab in the restore dialog and specify valid file names to be created for the
restored database. Or read up and use the RESTORE command from Query Analyzer, check out the
MOVE parameter.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Shailesh" <Shailesh@geminicorp.be> wrote in message
news:e19501c29169$31d4f9f0$89f
82ecf@TK2MSFTNGXA01...
> Dear Friends
>
> I amd getting the following error attached herewith in
> word file.
>
> The reason behind this is I have two servers for SQL 2000
> and i want to restore the backup of one server ServA to
> another server ServB but the problem is i have my data
> files on ServA on D: which is hard drive and Now when i
> am trying to restore it The D: on ServB is CD drive.\
>
> Please guide me through so that i can solve the problem.
>
> Thanks and best regards
> Shailesh Gothal



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net