March 15, 2010 at 12:39 pm
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 ......
March 15, 2010 at 1:47 pm
Are you moving only few databases or migrating server?
March 15, 2010 at 3:52 pm
Moving databases .. to new Server ..
March 15, 2010 at 3:54 pm
What is the size of the databases?
March 15, 2010 at 4:57 pm
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.
---------------------------------------------------------------------
March 16, 2010 at 6:12 pm
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