moving SQL SERVER 2000 DATABSES from one server to another that are running

  • moving SQL SERVER 2000 DATABSES from one server to another that are running

    the DTS packages are Running all the time .. and some other tasks are also running ..

    So , how can move the databases from one server to another server .. whithout Losing of the Task or Disable the DTS Packages or Without any loss of Records

    If any of you Gus have some Documentation oe Some Links ..Please Share ......

  • Are you moving only few databases or migrating server?

    EnjoY!
  • Moving databases .. to new Server ..

  • What is the size of the databases?

    EnjoY!
  • You are going to have to have an outage at some point, there is no way to avoid that.

    to minimise the outage the normal way is to get the new server all set up and ready to go and restore the user databases with no recovery so further tran logs can be applied, then when you actually fail over, stop all connections to the database, take one last log backup, apply it and bring the database online.

    USe sp_help_revlogin to transfer the logins to avoid orphaned users.

    To get your DTS packages/jobs etc over restore the msdb from the source server to the new server )SQLAgent down) and run

    update msdb..sysjobs set originating_server = 'new servername'

    DTS packages may fail if the servername is different.

    This is presuming the versions of SQL are exactly the same.

    ---------------------------------------------------------------------

  • Thanks .. For reply ..

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply