Viewing 15 posts - 46 through 60 (of 119 total)
Never mind. I was running the restore as a job step. The job was reporting success but the restore was failing because it could not get exclusive use...
November 21, 2011 at 5:44 pm
Thanks for the replies. I got it to work in a job with:
SET QUOTED_IDENTIFIER ON
GO
ALTER INDEX xxxxxxx
ON yyyyyyyy
REBUILD WITH (ONLINE = ON)
Could have sworn I tried that before, but...
October 5, 2011 at 11:45 am
That's good news. The part about "webpage has a redirect loop" made me want to suggest trying a different browser. I get that on some web pages with...
October 3, 2011 at 7:55 am
It's completely clean. Nothing out of the ordinary.
September 30, 2011 at 12:26 pm
It's been more than two weeks so it's hard to remember. 🙂 But I believe my resolution actually was to do the downloads with my laptop not connected...
September 30, 2011 at 9:34 am
It occurred to me, I am on my company's network now. A policy may be stopping the download. I will try it when I'm off the network.
July 26, 2011 at 9:35 am
Thanks. Definitely bookmarking that list at http://sqlserverbuilds.blogspot.com/
July 25, 2011 at 7:49 am
Yes, I understand how to do that. The job history shows the failure and the maintenance plan history shows success. I know that's not supposed to happen but...
May 11, 2011 at 2:31 pm
By "job report query" do you mean the process that logs the maintenance plan success/fail or something else? Can you share any hints for troubleshooting the job report query?
I...
May 11, 2011 at 7:09 am
Thanks for the ideas. BTW, the job failed again today 6:35am.
Yes, that message was from the job history. Another part of this mystery is that the...
May 11, 2011 at 6:49 am
Thanks. Those are good instructions but I have never had to install a SQL service pack manually on both cluster nodes (active then passive). I always run the...
May 4, 2011 at 6:37 am
The release date would just be a nice-to-have. I'd like to know when major service packs came out, just for reference. I know that info can be found,...
May 2, 2011 at 2:11 pm
I appreciate the SQL build lists on SSC.com and I refer to them often. But would it be possible to add the release date of each build, CU, SP?...
May 2, 2011 at 11:08 am
I would love to see "high performance" asynchronous Mirroring in Standard.
April 8, 2011 at 8:27 am
I found the answer to my question. If you are filtering on DatabaseID (as in > 5 to not see system databases) then Profiler will not show the deadlock...
March 30, 2011 at 1:43 pm
Viewing 15 posts - 46 through 60 (of 119 total)