Viewing 15 posts - 91 through 105 (of 107 total)
I would leave them on the same instance if you've not seeing any performance issues to save extra administration.
If you are having issues then it would might be worth installing...
May 20, 2011 at 5:21 am
Sorry, just re-read your post.. I see you've already tried that!
March 4, 2011 at 8:41 am
I would try taking a new snpahot and re-sync'ing with the subscriber.
March 4, 2011 at 8:39 am
I didn't know you could do it that either, but saying that, you can only do it that way if you have the option of restarting your sql service which...
February 18, 2011 at 10:16 am
Sounds about right. To confirm, I would;
- remove mirroring
- remove the mirrored db in recovery
- restore a copy of the primary db on the new luns with no recovery
- resume...
February 18, 2011 at 9:13 am
As a test, have you tried creating a sql account on server B and using that for the linked server authentication ?
February 18, 2011 at 9:04 am
Following on from the last post, insert a tracer token to see if the latency is between the publisher / distributor, or the distributor / subscriber.
January 15, 2011 at 4:11 am
Thanks for the responses chaps.
I'll have a look around, starting with McAfee. We currently use Sophos in our environment, which for some reason or another doesn't support active-active clusters, hence...
October 26, 2010 at 3:29 am
What happens when you try to reinitialize the subscription through replication monitor ?
October 22, 2010 at 2:25 am
We use Quest Spotlight and I think it's excellent.. I'm sure you can get trial downloads to see what suits you best.
October 5, 2010 at 7:19 am
I've just had a look through the other forums and I've re-posted to one more relevant to my question.
October 1, 2010 at 4:55 am
Try attaching and dettaching in 2005 before trying 2008 again.
September 20, 2010 at 5:36 am
If you try to shrink the log through SSMS how much free space does it say is available ?
September 14, 2010 at 7:01 am
Have you tried taking a tlog backup before performing the SHRINKFILE command ?
September 14, 2010 at 2:50 am
I'd double check the services have started.
September 8, 2010 at 7:42 am
Viewing 15 posts - 91 through 105 (of 107 total)