Viewing 15 posts - 6,451 through 6,465 (of 9,715 total)
Marco V (2/16/2011)
and
before restoring backups.
you can always try if you got the possibility to restart SQL server and hoping it start...
February 16, 2011 at 5:28 am
sqldba_icon (2/15/2011)
In all these i do not see the place where you mentioned "sp_add_jobserver"?
He's referring to a step referenced in his BOL link (click on the word...
February 16, 2011 at 4:40 am
Jamie Longstreet-481950 (2/16/2011)
The brain sleeps when it runs out of energy. Often it is smarter than we are.
Yeah, and supposedly I just woke up from a good night's sleep....
February 16, 2011 at 4:37 am
sqldba_icon (2/15/2011)
simon-811452 (4/9/2010)
This definitely happens when disabling from the GUI (see previous post). The system SP runs another SP, sp_sqlagent_notify, which clears the cache for the job; again, see previous...
February 16, 2011 at 4:34 am
Daniel Bowlin (2/15/2011)
Congratulations on publication.
WOTD: Thanks. @=)
February 16, 2011 at 4:25 am
john.arnott (2/15/2011)
Jamie Longstreet-481950 (2/15/2011)
CONVERT(varchar(8),getdate(),112)='20110215'
because it is easy to remember and there are...
February 16, 2011 at 4:24 am
GilaMonster (2/15/2011)
Brandie Tarvin (2/15/2011)
February 16, 2011 at 4:20 am
The problem is, we don't know what the problem is. Both GUI and script should work. GUI is not working properly, however. So stick with the script or, as I...
February 16, 2011 at 4:17 am
If db recovery is full, then your last full backup and every transaction log since can be used for restoring the database. Go into SSMS -> Databases, right click and...
February 15, 2011 at 12:41 pm
Nope. I can't even find these errors in the logs. It's like they happened, but didn't happen (according to the server logs). That's what's driving me nuts.
The earliest entry before...
February 15, 2011 at 12:23 pm
David Benoit (2/15/2011)
February 15, 2011 at 12:15 pm
sqldba_icon (2/15/2011)
Brandie Tarvin (2/15/2011)
Could it be that the job cache hasn't been updated since right after you disabled things?Could be..what do u mean by "job cache"..how can i check that?
Job...
February 15, 2011 at 12:09 pm
Could it be that the job cache hasn't been updated since right after you disabled things?
February 15, 2011 at 11:39 am
To add to what Nadrek just said, remember that just because the drive letter is different, doesn't mean the drive is different. Too many DBAs make the assumption that logical...
February 15, 2011 at 11:38 am
SQL Server does NOT track who created jobs, just the current owner of the jobs.
However, the work around is to create your own DDL trigger (if Create Job is one...
February 15, 2011 at 11:25 am
Viewing 15 posts - 6,451 through 6,465 (of 9,715 total)