Viewing 12 posts - 1 through 12 (of 12 total)
yes and also find the query
use msdb
select j.name ,
j.description location,
--h.run_date
CONVERT(CHAR(10), CAST(STR(h.run_date,8, 0) AS dateTIME), 111) RunDate,
case h.run_status when 0 then 'failed'
when 1 then 'Succeded'
when 2 then 'Retry'
when 3...
November 11, 2011 at 2:22 pm
ya i am sending you the query
use msdb
select j.name ,
j.description location,
--h.run_date
CONVERT(CHAR(10), CAST(STR(h.run_date,8, 0) AS dateTIME), 111) RunDate,
case h.run_status when 0 then 'failed'
when 1 then 'Succeded'
when 2 then 'Retry'...
November 11, 2011 at 2:19 pm
yup that is really good but it's giving the information about database backup
i need the success and failure details of backup jobs
November 11, 2011 at 1:29 pm
no other place tlogs are taking place
October 12, 2011 at 8:47 am
Hey i didn't say that i am getting error
it's taking long time to execute
intially i got out put like
closing master ......mdf and ldf files
and other databases
later it showed that...
September 15, 2011 at 11:13 am
just to understand the internal mechanism.
Regards,
Harish.
August 16, 2011 at 7:56 am
sure,
for instance,if i ask a person to call up some one obviously he picks up receiver and enters the number it will be transfered to telephone exchange and from there...
August 16, 2011 at 7:12 am
Thanks all
i will check perfmon for I/o stats.
as Roy said i will take backup locally and move to network later.
Thank you so much for your timely help ROY :-).
once i...
August 15, 2011 at 1:57 pm
Thank you very much Roy.
i am taking on network path only.
is there any thing we can do to fix this problem?
i would be glad to you, if you suggest me.
Regards,
Harish.
August 15, 2011 at 11:44 am
due to space issues,network issues
of course some times only one or two failures but i want to make it automate this can just write script for this..?
Regrds,
Harish.G
May 21, 2011 at 1:49 am
Viewing 12 posts - 1 through 12 (of 12 total)