Viewing 15 posts - 331 through 345 (of 1,271 total)
You have an unusual set up. Is there are reason why your mirror is still on SP2? Your mirror and principal should be on the same build level. You shouldn't...
May 3, 2012 at 11:59 am
Okay, so you're not talking about the state in sys.database_mirroring. You're talking about the state in the DATABASE_MIRRORING_STATE_CHANGE event (for WMI, event notifications, etc). It sounds like from your description...
May 2, 2012 at 8:20 am
I did a training session yesterday with a new person that MSL just hired (not the new PM, a different role) and went over the exam grading process. Hopefully, you...
May 2, 2012 at 7:53 am
I tried several approaches with this, many of which gave slightly improved results, but not by much. I tried "union all", persisted computed columns with and without check constraints on...
May 2, 2012 at 7:24 am
Is it generating mini-dumps when this error occurs? Are you able to manually create a snapshot of the database? If so, try running CheckDB on the snapshot and let us...
May 1, 2012 at 11:59 pm
You should take a look at my article in SQL Server Magazine (now SQL Server Pro magazine): Database Mirroring for Disaster Recovery
May 1, 2012 at 11:22 pm
You can configure thresholds in the log shipping configuration. If these thresholds are exceeded, the log shipping alert job will raise a failure.
May 1, 2012 at 11:18 pm
Because the job suceeded. The mirroring monitor job does not raise alerts if there are issues. It simply checks the health of mirroring and logs it. I know this is...
May 1, 2012 at 11:14 pm
Several comments here:
1. You cannot use DNS names with replication. Replication requires you use the actual server name.
2. Merge replication subscribers and publishers are not interchangeable. Data is merged bi-directional,...
May 1, 2012 at 11:12 pm
There is no such state as "Principal running exposed". The proper state for the scenario you outlined is "Disconnected".
The possible states for a mirroring session are:
DISCONNECTED -- partner disconnected from...
May 1, 2012 at 11:01 pm
If we're going to talk best practices, then SSAS should NOT be on the same server as the database engine. Since the vendor is saying that it is required to...
May 1, 2012 at 10:52 pm
There should be more to the error message than just that. Check the SQL Log to see if there is more info there. Also, what OS are you running?
May 1, 2012 at 10:46 pm
I don't know where the problem lies, but I suspect that it is actually an MSL issue. There is a process for defining what exams are required for each certification....
April 28, 2012 at 11:11 am
I forwarded a link to this thread to MSL already, but you can contact them via the email address mcmsqlexam@microsoft.com
April 25, 2012 at 10:02 pm
Viewing 15 posts - 331 through 345 (of 1,271 total)