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
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)