November 13, 2008 at 9:19 am
Hi
Assumptions:there are 2 machines with sql server 2000 installed namely sql1 and sql2.
sql1 and sql2 are under different domains.
the directory structures for both the machines are same, so the log files and the data files will be restored to the same drives on sql2 as they are on sql1.
i am trying to achieve the following :
I have to setup sql2 with all the objects that i have in sql1
the process i am following:
1.I am backing up all the databases on sql1 including Master,msdb,tempdb and all the application databases
2.I am restoring these backups on SQL2
After i do the restore , everything is working fine .My questions are as follows:
1.in Master.sysservers table there is an entry for sql1.after the restoration on sql2,this entry still remains the same pointing to sql1.do i have to update it to sql2?
2.in msdb.sysjobs table, the originating_server points to sql1 for jobs.do i have to update it to sql2?
3.what are the consequences that might come up if i am not updating these?
November 15, 2008 at 6:38 pm
I had to do the same thing last thing and I updated the msdb.sysjobs table to point to the new instance name , I didnt modify sysservers table .
I didnt encounter any issues.
regards
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply