Viewing 15 posts - 256 through 270 (of 2,840 total)
Do you have cross domain set up? How do you make sure that the Service account of Server A has all access to the Folder in Server B to copy...
-Roy
October 21, 2011 at 8:25 am
You have both the servers running under the same service account? They are not in the same domain, so how did you manage that?
Did you use identical local account?...
-Roy
October 21, 2011 at 8:13 am
Do you have Auto Stats on for the tables? Was the plan the same both the times or was it different?
What are you passing in as parameter that needs...
-Roy
October 21, 2011 at 8:08 am
How was the replication initially set up? Was it set up with Sync from backup? If so everything will look normal but none of the changes will go through until...
-Roy
October 21, 2011 at 5:55 am
That means you are having bottlenecks/Blocks somewhere. it could be Network IO or disk IO or any blocks. Our latency is around 3 sec and our OLTP server is Kinda...
-Roy
October 20, 2011 at 9:32 am
I found another thread that deals with the same issue. Check the last page here. You will see the work around.
-Roy
October 20, 2011 at 8:38 am
We have been using Tran replication for years for reporting. It has been quite stable. But if you have Network problems and HW problems, it can become tough to maintain....
-Roy
October 20, 2011 at 8:34 am
The answer is still It Depends. With no detail of what you are doing in your warehouse and what your OLTP DB does and store, it will be difficult to...
-Roy
October 20, 2011 at 8:19 am
Brandie, I think there is another one cause I remember distinctly that you have to do a EMPTYFILE before you try to delete the secondary file once again after creating...
-Roy
October 20, 2011 at 8:17 am
YES or It Depends is the answer. Without more details it will be difficult to even guesstimate.
-Roy
October 20, 2011 at 8:07 am
As far as I know, NO. You can check the default trace to see if it is registered there.
The best way would be to set Auditing on the table...
-Roy
October 20, 2011 at 8:03 am
If I am not mistaken this is a bug in SQL Server 2008. It has not been fixed in SQL 2008 R2 either. I think there is also a pss...
-Roy
October 20, 2011 at 7:31 am
It specifies how you are synching the data to the subscriber.
-Roy
October 19, 2011 at 2:15 pm
Ah, So not a stupid question. I am glad that you got it fixed.
-Roy
October 19, 2011 at 2:12 pm
Yes, that is what I meant. It is set pretty high.
Just one stupid question, this is not a named instance, right?
-Roy
October 19, 2011 at 11:42 am
Viewing 15 posts - 256 through 270 (of 2,840 total)