Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
nachi
Starting Member
7 Posts |
Posted - 2005-10-07 : 02:19:33
|
Hi,We are moving SQL Server 2000 database from one server to another server. I want to know the installation steps for moving the database.We need to move the MDF File, Tranasaction File, Error Logs, Jobs, Logins, Permissions, Full Text Catalog, Setting Proxy account properties for SQL Server Agent.If any one has done this in previous, please let me know the steps to be followed. Also if you have any documentation, please email it to nachiappan_s@lycos.com |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
nachi
Starting Member
7 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2005-10-07 : 02:32:24
|
If its a new installation you could also move/copy the master and msdb databases - i.e. the new machine would be a "replica" of the original.Is that an option?Kristen |
|
|
nachi
Starting Member
7 Posts |
Posted - 2005-10-07 : 03:29:41
|
I'm not sure what exactly you mean by this statement "If its a new installation you could also move/copy the master and msdb databases - i.e. the new machine would be a "replica" of the original."Yes its a new installation on the new server. but we have 2 application databases created on the old server which needs to be moved along with logins and permissions of that two application database |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-07 : 03:44:21
|
I was meaning "Are you moving the database to an existing server that already had databases on it."As that is NOT the case then you have the option to copy the master and msdb databases to the new server too - that will reproduce an identical environment to what you currently have - users, jobs, etc.I believe that you do need to have the databases on the same drive/path as the old machine (at least to start with, you could move them thereafter)Its not something I have done, but I have seen TDuggan mention it many times on SQLTeam.http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=41453http://support.microsoft.com/default.aspx?scid=kb;en-us;224071Kristen |
|
|
|
|
|
|
|