| Author |
Topic |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-05-26 : 01:54:29
|
| Hi,My database in MSSQL Server is around 27 GB.I am the only DBA over here. I have not enough experience in SQL.Now I have to implement Replication. My choice is transactional replication.My subscribed database is in other location. I followed the steps for replication. The problem is that it is taking lot of time to copy tables from production database. Is it possible to first recover the subscribed database with rescent backup and then replicate it? Gurus, please explain. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-26 : 12:57:18
|
| What environment are you replication to? You are replicating from production but are you replicating to another production environment? If you aren't, then you shouldn't be using replication.Tara |
 |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-05-27 : 01:49:29
|
| I am not replicating production to another production.I am not using Merge replication. I want a copy of the database. Every time when user is doing an entry in the production database, it should reflect to the copy database in other location also. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-05-28 : 01:30:45
|
| Hi,Can anyone help?Actually I am trying to make a High Availability System (Like what Dataguard does in Oracle 9i).I am facing problems on replication.Some of the tables are not replicating. I am giving you some messages given by Replication (Distribution) Agent.----------Bulk coping data into table 'AR_OUTSTAND'Table "AR_OUTSTAND":100000 row(S) copied. Total:300000Bulk copying data into table 'AR_COLL_HD'Table "AR_COLL_HD":100000 row(S) copied. Total:100000Bulk copying data into table 'AR_CRN_PROD_HD'The process could not bulk copy into table "'AR_COLL_ADJ'"-------------I didn't find any difference (problem) in 'AR_COLL_ADJ' from other tables. There are lot of tables like this. Why it has taken "' instead of ' ?I disable the constraints in the article - table defaults. The same thing happened again.Did anyone experience this? Please help me if you can. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-05-28 : 04:51:17
|
| Have you considered Log Shipping instead of Replication?-------Moo. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-28 : 12:20:23
|
| Replication is not for high availability or disaster recovery. You should consider Log Shipping to a disaster recovery site and clustering for high availability for this type of solution.Tara |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-01 : 07:31:35
|
| But the above is not a solution to my problem. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-01 : 08:46:32
|
Why not? What is your problem  -------Moo. :) |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-10 : 01:35:29
|
| Hello Mr. Moo,I was not asking about log shipping. It is one of the best method for disaster recovery. But when I try to replicate me database, why it is giving me this errors ? If somebody experienced it and found some remedies, I was requesting them to share. I don't understand why it gives error for some of the tables.Do you find any problem with me?If you find any problem, I will try log shipping also. But also I am curious to know the remedy for my problem with replication.KIND ATTENTION : Ms. Tara.I hope replication can be used for disaster recovery also, correct me if I am wrong. One more, is there any perforance impact when I use Log Shipping ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-10 : 12:29:34
|
| Replication is not for disaster recovery. There is no performance impact with log shipping. We've been running it for a few years now.Tara |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-15 : 08:49:25
|
| Ok. Thanks.But replication means it makes a copy of the database, right?What ever it updated in the Main, it will update there in the Subscriber also. Considering this I said the above statement. Yes, I tried log shipping is the best way to make a Standy.Once again thanks for your support. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-16 : 12:31:47
|
| Replication is usually not for the entire database. Typically, you only replicate certain objects.Tara |
|
|
|
|
Replication after Recovery