Moving the database

Hi,
We have 15 databases in 15 different servers. Now we have got a very high en
d machine, to which we would like to move all these 15 databases. What is th
e best method to do this?
I cannot take any of the database's offline and I need to transfer all the l
ogins from these individual servers to the new server.
Please advise.
Thanks
GYKYou could use BACKUP/RESTORE. You could also script all logins in Enterprise
Manager. For moving logins, see:
http://support.microsoft.com/default.aspx?kbid=246133
For more information on this topic, see:
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:0D4A8514-8493-40BF-8065-8AFA9F8403C3@.microsoft.com...
Hi,
We have 15 databases in 15 different servers. Now we have got a very high
end machine, to which we would like to move all these 15 databases. What is
the best method to do this?
I cannot take any of the database's offline and I need to transfer all the
logins from these individual servers to the new server.
Please advise.
Thanks
GYK|||Hi Vyas,
Thanks for the info. How about using "COPY DATABASE" wizard? Or using DTS Im
port/export wizard? Are there any disadvantages using this, when compared to
BACKUP/RESTORE?
Thanks
GYK|||Hi Gyk,
Perform the below the steps,
1. Execute SP_DETACH_DB in each servers
2. Copy the .mdf and .ldf to thenew server
3. Perform the step - 1 and step -2 for all servers
4. From the new high end server use SP_ATTACH_DB to attach the databases
5. Using EM to create the Login scripts or USE DTS LOgin transfer to create
the logins
Thanks
Hari
MCDBA
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:DAC385AD-6346-4559-BC20-B1E64190079D@.microsoft.com...

quote:

---

> Hi Vyas,
> Thanks for the info. How about using "COPY DATABASE" wizard? Or using DTS

---

Import/export wizard? Are there any disadvantages using this, when compared
to BACKUP/RESTORE?

quote:

---

> Thanks
> GYK

---

|||For your requirements, BACUP/RESTORE will provide you with exact copy of the
database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:DAC385AD-6346-4559-BC20-B1E64190079D@.microsoft.com...
Hi Vyas,
Thanks for the info. How about using "COPY DATABASE" wizard? Or using DTS
Import/export wizard? Are there any disadvantages using this, when compared
to BACKUP/RESTORE?
Thanks
GYK|||All the other sugestions will work.
However you will need to take the database off line.
Let me tell you why...
Database A is to being used to add data.
Database A is backed up - moved ect
.
.
Database B is created using Database A
Now during the time taken to create Database B, Database A
is still being used.
So Database A may contain data that database B hasn't.
The solution is to take Database A offline to users then
perform your move.
Personally I would create the table structure on the new
server first, then copy the data using DTS, the reason is
so you don't have to mess around with data / log files.
J

quote:

---

>--Original Message--
>Hi,
>We have 15 databases in 15 different servers. Now we have

---

got a very high end machine, to which we would like to
move all these 15 databases. What is the best method to do
this?

quote:

---

>I cannot take any of the database's offline and I need to

---

transfer all the logins from these individual servers to
the new server.

quote:

---

>Please advise.
>Thanks
>GYK
>
>.
>

---