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 to
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? 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
>>
>|||PS: I tried the procedure that you outline in your message and the DB restored
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? 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
>>
>

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...
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?
Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\dat a\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/default...224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\data\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>

Move SQL Databse (in MSDE) to another path

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?Hi,
Login to SQL Server using OSQL -Usa -Ppassword -Sservername (Enter)
This will allow you to go to a SQL prompt there type the below command to
detach the database (Only for User databases)
1>sp_detach_db <dbname>
2>go
Now you can move the MDF and LDF files to new partition say D:\MSSQL\DATA
After that use the below command in the SQL prompt:-
1>sp_attach_db
'dbname','d:\mssql\data\dbname.mdf',''d:\mssql\data\dbname.ldf'
2>go
The above command will attach the database back to SQl Server but in new
partition.
Note: Do the above steps for all the other user databases as well as
Pubs,Northwind.
If you need to do the same for system databases (Master, model , tempdb,
msdb), follow the below link. The link also details movement of user
databases.
http://support.microsoft.com/defaul...;224071&sd=tech
Thanks
Hari
MCDBA
"Batista" <carlos.batista@.cmz.pt> wrote in message
news:ac3b01c43692$bc1bf350$a501280a@.phx.gbl...
> I have a server W2K (and MSDE) with 2 partitions one for
> system (3GB) and one for data (37GB).
> An application creates ALL SQL databases, in the default
> folder for MSDE 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data' in the system partition.
> It intended to move the databases for the data partition?
>