June 17, 2008 at 12:30 pm
Hello,
Can anyone find fault in migrating all databases, jobs, logins etc from one machine to another machine by copying the D:\SQLDATA\MSSQL directory and all its contents to the same directory on another machine? I can guarantee the following for this migration:
* The sql server 2000 is set up the same on both machines prior to the copy.
* Down time is not an issue. Both sql servers can be shut down for this.
* Both machines have the same databases, users, jobs etc prior to the copy but the data within several databases is different.
* The machine names for the two computers are different.
* The hardware is different on the two machines.
This procedure would be used when one machine needs to replace another (ie when there are hardware issues with the original machine)
Thanks for any help you can offer,
Rob
June 18, 2008 at 2:29 pm
The different computernames can cause issues.
June 18, 2008 at 3:08 pm
June 18, 2008 at 5:03 pm
This folder contains all the databases, jobs, logs, replication data, users ...
Essentially, all the data for sql server is contained in this directory structure.
June 18, 2008 at 5:05 pm
Is there somewhere in the databases where the machine name is stored?
June 18, 2008 at 6:19 pm
The instance name is stored in master, but changing that is well documented.
You will also need to update the originating_server in sysjobs (does not apply to SQL 2005)
There will also be issues with any logins that are local machine logins and not domain logins.
June 19, 2008 at 10:42 am
Thank you for the information. I will look at this.
Rob
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply