Viewing 15 posts - 871 through 885 (of 1,583 total)
Are you running this backup task via Maintenance Plan or via your own custom TSQL?
If running via a Maintenance Task, simply open up the corresponding SQL Agent job that was...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 12:30 pm
The "The job was stopped prior to completion by Shutdown Sequence 0" can be attributed to all kinds of things i.e.(server is extremely busy, hardware issues (lack of RAM, etm,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 11:49 am
If you have more than one tempdb data file, be CERTAIN to size them the exact same size and make sure you do not have autogrowth set to ON, size...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 7:57 am
The data being passed (varchar value) is too large for the datetime datatype. You haven't posted any code so its tough to tell you where that may be coming...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 23, 2012 at 11:24 am
Yes it is possible but there will be a lot of "activity" on the server, especially if it's a busy server.
Why would you want it all on the same box?...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 22, 2012 at 11:29 pm
Yep that's the one. It may be old but it works. "Electricity" is quite old, but still works all the same 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 22, 2012 at 11:12 pm
Forgetting the linked server issue, can you run it directly on the reporting server from a job?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 22, 2012 at 11:10 pm
Wow, I must have missed that you were trying to start a reporting service subscription :w00t: The error you posted has nothing to do with the fact you can't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 22, 2012 at 7:38 am
I am pretty certain this will work, specify the @job_name parameter...
EXEC ('msdb.dbo.sp_start_job @job_name=N''stakeholderTEST''') AT [TK5BITOOLSVM01];
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 10:44 pm
Ninja's_RGR'us (12/21/2012)
I get them just fine.
I get them, they're just coming in several hours after-the-fact, last night it was after 10pm CST before I got post notifications from 4-5pm earlier.
Just...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 2:44 pm
Lynn, the actual execution plan is the first first attachment in my original post
BTW - what is up with SSC today not delivering notifications for posts???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 2:29 pm
To reiterate, the main purpose of me posting this was to see if there was a better way to accomplish these multiple table self joins, not particularly getting it "faster",...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 1:37 pm
It's all good:-D I appreciate constructive criticism(s)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 1:18 pm
Taking this with a grain of salt and the "it depends" answer, another way to see if you have disk contention is to track the average disk queue length for...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 1:03 pm
That still does not resolve the issue of someone having a job_id parked in some code somewhere and that job_id ceasing to exist when a job is dropped and recreated
Very...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 9:34 am
Viewing 15 posts - 871 through 885 (of 1,583 total)