Moving a DB from 1 Server 2 another

Hi all,
I have a databse on an SQL Server 2000 that I need to move to another
one.
If I can get a network connection between both servers, I can do this
easily
within Enterprise Manager, but what if I need to physically take the DB
to that server? Assuming that I can't get a network connection, how
would
I get the DB into the other server?
I backuped the DB and tried to restore it on a second test server that I
have,
but I could not get the Restore process to locate the backup file.
Thanks for your time and assistance.
SagaSaga,
Did the account have access to the directory containing the backup file?
Try Restore Database --> From Device --> Select Devices...--> Add... -->
Then click the elipses button and choose the backup filename.
Also, check out:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/en-us
HTH
Jerry
"Saga" <antiSpam@.somewhere.com> wrote in message
news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have a databse on an SQL Server 2000 that I need to move to another one.
> If I can get a network connection between both servers, I can do this
> easily
> within Enterprise Manager, but what if I need to physically take the DB
> to that server? Assuming that I can't get a network connection, how would
> I get the DB into the other server?
> I backuped the DB and tried to restore it on a second test server that I
> have,
> but I could not get the Restore process to locate the backup file.
> Thanks for your time and assistance.
> Saga
>|||Thanks Jerry!
I will have a look at the info that you mention. I got lucky... I was able t
o
register both SQL Servers in my Enterprise Manager, so the DB transfer
went along perfectly, but I am going to look into the info that you mention
because whenever I will need this I know I will need it bad :-)
Regards
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>|||PS: I tried the procedure that you outline in your message and the DB restor
ed
beautifully!
Thanks again
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>