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 |
|
davecarrera
Starting Member
4 Posts |
 Posted - 2008-05-01 : 08:51:23
|
| Hi All,Bit new to SQL so here gose.I have a sql server that i would like to replicate to a second box, which is on my lan at the moment for testing but will be moved offsite and linked into my network via vpn later. I have never used replication before so i would like to know what is the best way to set it up, test it.Running MSSQL 2000 on both machines.Databases about 7gigBoth on win 2003 serverMany kind regardsDave C |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-01 : 09:56:43
|
| Why are you looking to Replicate? Is the second box going to be a live server, for reporting, for any other use or just a backup?Depending on the way you set up replication (if that is what is required), it should not be a problem setting it up and then moving it (assuming the IP Address/Server Name is going to stay the same.Setting up replication for your example, you obviously want the first box as the publisher & distributor, and the second as the subscriber. As your database is currently 7GB, this shouldn't be a problem, but if there is future scope for scalability or the usage is likely to be heavy, then you may want to use a seperate server as your distributor. Again, this would depend on requirements.As for going about physically setting it up, you can do this through EM (the easiest way to do it first time you use replication). On the menu, under tools (I think, don't quote me on that as do not have 2000 installed on the machine i'm on), Choose Replication, Configure Publishing, Subscribers & distribution, the pop-up is pretty self explanatory.Once this is completed, you can then create publications, subscriptions etc..Be aware that when you configure replication on a database, the table structures are change and an unique identifier is added to your tables. You will need to take account of this in any select * scripts you have. |
 |
|
|
|
|
|
|
|
replication ????