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...
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?...
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...
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...
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...
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.
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....
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...
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...
October 20, 2011 at 8:17 am
YES or It Depends is the answer. Without more details it will be difficult to even guesstimate.
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...
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...
October 20, 2011 at 7:31 am
It specifies how you are synching the data to the subscriber.
October 19, 2011 at 2:15 pm
Ah, So not a stupid question. I am glad that you got it fixed.
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?
October 19, 2011 at 11:42 am
Viewing 15 posts - 256 through 270 (of 2,840 total)