|
Subject:
|
How to transfer DB between two servers.....
|
|
Posted By:
|
srinivasparimi
|
Post Date:
|
9/6/2006 8:27:40 AM
|
Hi...
Here is my doubt,
1. how can i transfer the data(Full Database) between two servers,
the servers are in two different locations....
any some good ideas..
thanks
|
|
Reply By:
|
dparsons
|
Reply Date:
|
9/6/2006 8:34:05 AM
|
If you are trying to move the database 'People' from server a to server b do this:
On server B create a Database called People through enterprise manager then Backup the database.
Take the MDF and LDF files from server A and place them on Server B and now go and restore the database using the MDF and LDF files from server A and viola, the database will be the same across both servers. (The only thing you will have to make sure is that the Physical Path of the LDF and MDF files are correct)
hth
"The one language all programmers understand is profanity."
|
|
Reply By:
|
srinivasparimi
|
Reply Date:
|
9/6/2006 10:23:36 AM
|
thx for ur reply....
I want to transfer the database and also maintain the stand-by server..., i think for that REPLICATION is there, but i dont no that it will work for two servers are in different locations...
tell me some other procedures like "replication"....
thanks...
|
|
Reply By:
|
dparsons
|
Reply Date:
|
9/6/2006 10:25:31 AM
|
Create a DTS package, though I have had bad luck with trying to copy Databases between servers using DTS process's.
"The one language all programmers understand is profanity."
|
|
Reply By:
|
srinivasparimi
|
Reply Date:
|
9/6/2006 10:49:12 AM
|
thx for ur reply...
I think In DTS Pkg's, there is no stand-by server property....
If source server was updated, the destination won't update till DTS pkg run.....
thats y i am asking about any stand-by server mechanisms...
thanks...
|
|
Reply By:
|
dparsons
|
Reply Date:
|
9/6/2006 11:23:24 AM
|
I don't know what you mean by "stand-by" server but what you are talking is replication, plain and simple.
"The one language all programmers understand is profanity."
|
|
Reply By:
|
prabhakaran
|
Reply Date:
|
12/1/2006 2:11:20 AM
|
you can try log shipping to create standby server
Thanks,
Prabhakaran
|
