Viewing 15 posts - 961 through 975 (of 1,319 total)
I don't see anything in the logs but I suspect permissions. Does the account running SQL server agent have appropriate rights to serverB? Trying logging into serverB using the agent...
-- You can't be late until you show up.
August 12, 2008 at 8:07 am
Right click on the job under SQL Server Agent->Jobs. Then view history and check the "show step details" box. Highlight the failing step. It should provide more detailed info as...
-- You can't be late until you show up.
August 12, 2008 at 7:16 am
What type of job are you executing? Is it writing a file? Is it a maintenance job (index rebuild, etc.)? What type of error is being logged for the job?...
-- You can't be late until you show up.
August 12, 2008 at 6:59 am
Gail, would you recommend always running with repair_build or repair_fast? If not, why not? I've never used these options but in the OP's case, it might have fixed everything related...
-- You can't be late until you show up.
August 8, 2008 at 9:50 am
GilaMonster (7/23/2008)
-- You can't be late until you show up.
August 8, 2008 at 9:40 am
The service pack will work. And, trust me, it's a good thing to keep the client as patched as the server, however you do it.
GSquared - thanks for the tip....
-- You can't be late until you show up.
August 8, 2008 at 9:21 am
Absolutely. That's also a good way of doing backups of VLDBs, especially if using native SQL. Allows you to slice it and dice it to meet your business recovery needs....
-- You can't be late until you show up.
August 8, 2008 at 6:19 am
As I'm leaving for the day and don't have time to create a more robust example, try this on Northwind. Ten bucks says you get the same results...If you don't...
-- You can't be late until you show up.
August 7, 2008 at 2:50 pm
Unless I am totally missing something, wouldn't this do what you're looking for??
declare @lessdate = datetime
declare @greaterdate = datetime
set @lessdate = convert(datetime, '03/07/2008', 103)
set @greaterdate = convert(datetime, '03/07/2008', 103) +...
-- You can't be late until you show up.
August 7, 2008 at 1:58 pm
ch.mohini (8/6/2008)
check history of job & reschedule it
Why are you opening threads where an obvious resolution has been found or offered already, while adding little or no value to the...
-- You can't be late until you show up.
August 7, 2008 at 1:46 pm
Sounds like a good plan. Good luck.
-- You can't be late until you show up.
August 7, 2008 at 1:38 pm
ch.mohni (8/7/2008)
truncate the Temp db & change the recovery model to simple
TempDB's recovery mode is always set to simple....
-- Edit - The most important lesson to be taken from this...
-- You can't be late until you show up.
August 7, 2008 at 1:37 pm
dba_ch (8/7/2008)
add additional file
This will work only if it's added to a different physical drive that has space available....
-- You can't be late until you show up.
August 7, 2008 at 1:33 pm
Watch which forum you post in, this is SQL2005. Anyway, check out the link below. Are these log backups or full? It appears logs based on the MS article. If...
-- You can't be late until you show up.
August 7, 2008 at 1:24 pm
Sorry, no experience on 64 bit (I assume that's what you mean), only 32 bit (I assume that's what you mean, also 😀 ). As far as user DLLs, I'm...
-- You can't be late until you show up.
August 7, 2008 at 9:27 am
Viewing 15 posts - 961 through 975 (of 1,319 total)