Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||It might be worth mentioning that for SQL Server logins, a new SID is generated by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search KB).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > What is the best and safest way to copy about 55 Databases from a server
> > running win2k to a new server running Win Server 2003 Ent. Ed. What are
> > the different options do i have? Can I copy all the current Db plans,
> jobs,
> > and Logins? What is a good practice for doing this? The win2k server is
> in
> > production right now. Do i have to shut it down?
> Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
> Transfer Logins task. For jobs and other things, you can backup and restore
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > > What is the best and safest way to copy about 55 Databases from a
server
> > > running win2k to a new server running Win Server 2003 Ent. Ed. What
are
> > > the different options do i have? Can I copy all the current Db plans,
> > jobs,
> > > and Logins? What is a good practice for doing this? The win2k server
is
> > in
> > > production right now. Do i have to shut it down?
> >
> > Copy Database Wizard in EM is quite nice. You can transfer logins using
DTS
> > Transfer Logins task. For jobs and other things, you can backup and
restore
> > the Msdb database.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> >
>