Changing physical SQL Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Yannick Turgeon
    #1

    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.

    Yannick


    Tags: None
    • louis
      #2
      Re: Changing physical SQL Server

      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.

        Comment

        • Yannick Turgeon
          #3
          Re: Changing physical SQL Server

          Thanks for that Louis.

          Yannick

          "louis" <louisducnguyen @gmail.com> wrote in message
          news:1105044803 .604211.75490@z 14g2000cwz.goog legroups.com...[color=blue]
          > 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.
          >[/color]


            Comment

            Previous template Next
            Working...