Viewing 15 posts - 31 through 45 (of 56 total)
Assuming those jobs don't overlap each other then that alone is worth 132 Mbytes of the 512. If they do overlap then it will be larger yet. What...
July 7, 2011 at 8:55 am
Yes 64-bit wasn't an option for me either, in fact I still have this DB server running in production. Anyway, the next question I would ask is, "How many...
July 6, 2011 at 8:58 am
I have experienced this exact issue and found that there wasn't one specific way to solve it, short of migrating to a 64-bit environment. After significant research the error...
July 5, 2011 at 3:42 pm
Well normally I'd say start with sys.database_mirroring and sys.database_mirroring_endpoints, but I don't think those contain any time information. You could look at database mirroring monitor and it should show...
June 30, 2011 at 4:54 pm
Jeffrey, thanks for the reply, After spending the day researching this, I now understand the difference. You are correct this is high performance mirror for DR purposes.
Based on...
June 15, 2011 at 3:45 pm
The answer is, run this on each endpoint:
ALTER ENDPOINT YourDBMirrorEndPoint STATE = STARTED
March 17, 2011 at 3:05 pm
Does anyone have any troubleshooting ideas? I'm working on getting Microsoft support involved but it looks like that's going to take a little while.
September 27, 2010 at 10:05 am
The mirror broke on that day, it recovered nicely though once everything smoothed out. The mirror issues and the MSDTC issues never recurred. There are only 10 databases....
September 24, 2010 at 4:39 pm
No linked servers, I've been going through the trace file trying to find bulk inserts actually and haven't seen any. So I'm going to say inconclusive on that.
Attached is...
September 24, 2010 at 3:52 pm
LOL, nevermind this post, I figured it out. It was a typo!
March 8, 2010 at 10:45 am
I'm not sure if this is an option for you but if you don't need realtime replication, which can sometimes get hung up and delayed anyway if the publisher is...
September 14, 2009 at 5:22 pm
Oh, nevermind, I see the var @searchstring is length 50. my mistake, I can adjust that.
False alarm! 🙂
September 14, 2009 at 11:50 am
Lowell, one quick question for you, I've been using this a bit this morning and the sql that it's generating for the sql varchar is displaying like this:
SELECT *...
September 14, 2009 at 11:45 am
Lowell, it works great, does exactly what I need, you my friend are a saviour!
Both of you, thank you for all your help today. I really appreciate it.
September 11, 2009 at 4:24 pm
forgive me, I still have questions...
Where is the schema information stored? It's not in sysobjects that I can tell.
I went through these tables, and it looks like there are...
September 11, 2009 at 3:56 pm
Viewing 15 posts - 31 through 45 (of 56 total)