Viewing 15 posts - 301 through 315 (of 4,745 total)
In sqlagent properties there is a history tab, if the log history size is too small and you have a lot of jobs, history will be truncated sooner than you...
---------------------------------------------------------------------
February 18, 2014 at 7:26 am
TomThomson (2/18/2014)
Thomas Abraham (2/18/2014)
Isn't this a repeat of the question Steve posted 02/22/2012?? (Or at least the first part of Steve's question.)
Yes.
The discussion is a bit less interesting this time,...
---------------------------------------------------------------------
February 18, 2014 at 7:15 am
paul.knibbs (2/18/2014)
---------------------------------------------------------------------
February 18, 2014 at 6:02 am
sorry posted wrong script! I have edited script above.
---------------------------------------------------------------------
February 17, 2014 at 4:57 am
nadersam (2/16/2014)
What if i need to get the query not the object as many queries could be using the same object, anyway to do that?.Thanks
From Glenn Berrys diagnostic script
-- Top...
---------------------------------------------------------------------
February 17, 2014 at 4:30 am
Gary Varga (2/14/2014)
Thomas Abraham (2/14/2014)
BWFC (2/14/2014)
The cynics amongst us might say there are two appropriate answers though!
My experience is that $ spent on Valentine's Day, or any odd Wednesday, on...
---------------------------------------------------------------------
February 15, 2014 at 2:58 pm
As you want the size of the backup file why don't you go straight to the backup information in msdb..backupset rather than estimate from file information?
something on these lines?
declare @dbname...
---------------------------------------------------------------------
February 15, 2014 at 5:37 am
weird, display it it in grid mode it looks like a squared off O of perhaps square brackets []
---------------------------------------------------------------------
February 14, 2014 at 3:26 am
via sp_readerrorlog. see here
---------------------------------------------------------------------
February 10, 2014 at 4:03 pm
they are terms which are often used in an interchangeable manner, but mirroring and clustering are better for HA because they can provide automatic failover, log shipping cannot, therefore log...
---------------------------------------------------------------------
February 10, 2014 at 3:55 pm
ScottPletcher (2/7/2014)
No real DBA would ever use a maintenance plan;
thats a bit over the top surely?
Nowhere does it say using maintenance plans per se is not good practice....
---------------------------------------------------------------------
February 7, 2014 at 2:07 pm
SQLAgent is a job scheduler, but for a job to run to a schedule, both the job itself and the schedule have to be enabled. If either are disabled the...
---------------------------------------------------------------------
February 7, 2014 at 1:44 pm
run the installer from a location that ALL the nodes can see.
---------------------------------------------------------------------
February 7, 2014 at 10:46 am
there is no way to totally disable a job so it cannot even be run manually. All the disable option does is prevent the job running as a scheduled job.
you...
---------------------------------------------------------------------
February 7, 2014 at 10:40 am
two minutes have passed, has the log restored now?
---------------------------------------------------------------------
February 6, 2014 at 8:16 am
Viewing 15 posts - 301 through 315 (of 4,745 total)