Changing physical SQL Server

Hello all,

We are in the process of upgrading our SQL physical server (with SS2k). In
the process we will change the OS form NT4 to W2K. What is the best way to
copy all my databases and SQL logins, roles, jobs, alerts, etc. from my
actual (old) SQL Server to my new one?

Thanks for your time.

YannickTransfer logins: see msft support article KB 246133

Transfer databases: backup and restore the Dbs on the new server. This
should copy the permissions and roles. (I recommend ftp'ing the backup
files from one server to another. I learned this the hard way.)

Transfer jobs & alerts: I don't know an easy way. I used EM to
generate sql scripts for each one and then ran them on the new server.|||Thanks for that Louis.

Yannick

"louis" <louisducnguyen@.gmail.com> wrote in message
news:1105044803.604211.75490@.z14g2000cwz.googlegro ups.com...
> Transfer logins: see msft support article KB 246133
> Transfer databases: backup and restore the Dbs on the new server. This
> should copy the permissions and roles. (I recommend ftp'ing the backup
> files from one server to another. I learned this the hard way.)
> Transfer jobs & alerts: I don't know an easy way. I used EM to
> generate sql scripts for each one and then ran them on the new server.

Changing IP's on SQL cluster nodes

Hi, I'm having the same problem that was posted earlier this month. In
the thread there was no resolution of how the issue was solved.
Has the issue been solved? If so, how?
Thanks
Couple of articles you may want to read:
http://support.microsoft.com/?id=244980
http://support.microsoft.com/default.aspx?kbid=230356
Not sure what other thread you are talking about.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Jose Lopez-Alvarez" <JoseLopezAlvarez@.discussions.microsoft.com> wrote in
message news:1059CABF-28E2-4690-BDAC-F23B9AC94ED6@.microsoft.com...
> Hi, I'm having the same problem that was posted earlier this month. In
> the thread there was no resolution of how the issue was solved.
> Has the issue been solved? If so, how?
>
> Thanks
|||Hi Rodney, I was refering to the post called "URGENT: Changing IP's on SQL
cluster nodes". I the same situation the author has. There was no solution
posted for his problem.
"Rodney R. Fournier [MVP]" wrote:

> Couple of articles you may want to read:
> http://support.microsoft.com/?id=244980
> http://support.microsoft.com/default.aspx?kbid=230356
> Not sure what other thread you are talking about.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Jose Lopez-Alvarez" <JoseLopezAlvarez@.discussions.microsoft.com> wrote in
> message news:1059CABF-28E2-4690-BDAC-F23B9AC94ED6@.microsoft.com...
>
>