November 5, 2009 at 1:14 pm
Hello-
I have two SQL 2005 Servers, one is a production and one is a test server. Could someone help me with setting up a replication job? After the production server is done backing up, I want it to replicate to the test server... Can anyone help me?
November 5, 2009 at 5:52 pm
I think this is the wrong forum. If you are talking about replication between two SQL 2005 boxes, I think your question would go there. This is for 2000 replication.
What are your requirements? Do both servers need to be able to make changes that are replicated to the other server? Does just one server need to be able to keep another server up-to-date with information? Because if that is the case, then database mirroring or log shipping may be a better way to go.
Joie Andrew
"Since 1982"
November 6, 2009 at 6:11 am
Ok, all I need is to have the production server copy the backup to the test server.
November 6, 2009 at 12:55 pm
You could use transactional replication to get what you want. Alternatively, you may be able to get what you need from Log Shipping. The only thing is I do not remember if a Secondary Server in Log Shipping stays in a "recovering" state until it is manually brought into a ready state, like mirroring. I do not think that is the case, but you may want to do do some more research on the topic.
Joie Andrew
"Since 1982"
November 6, 2009 at 1:22 pm
Transactional Replication is an option, there is no doubt about it.
Before configuring you need to figure out who is the distributor, since configuring local distributor would have some performance overhead (the Server is in Production and you would not want people complain about System being Slow) and also depends on the amount of Data that is Added / Changed on a daily basis.
You can also think about SSIS Packages to do this for you.
By the way what is the Size of the Production Database and how much does it grow on a day to day basis?
Log shipping can be configured with no recovery mode, but you cannot use it, if you need to see the data. OR in Standby Mode (read only), but would be only to read that Data and you cant change the data if you wanted to test.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 6, 2009 at 1:27 pm
The database is 4GB, it grows a little each day.. The backup is ran in the middle of the night, so I would like it to rep over to the test server right after that... It was setup on these servers when there were SQL 2000 ( i did not set them up) we recently upgraded them to 2005
November 6, 2009 at 1:41 pm
If you choose transactional replication, my guess is you have no choice of controlling the replication after backups in the Nights etc.
The better way is to go with SSIS Packages.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply