Post reply

Full Backups Quit Working

  • October 27, 2009 at 2:53 pm

    #1071463

    Just re-create it. It will surely solve your problem. 🙂

  • October 27, 2009 at 3:08 pm

    #1071472

    Hi mcvilbar

    what do you mean by re-create ?

    surely not from a new plan and add everything back in ?

    way too much work

    Thanks

    Jim

  • October 28, 2009 at 12:16 am

    #1071558

    You can just run this to see what has happened to your backup

    SELECT

    ld.line1 AS [Line1],

    ld.line2 AS [Line2],

    ld.line3 AS [Line3],

    ld.line4 AS [Line4],

    ld.line5 AS [Line5],

    ld.server_name AS [ServerName],

    ld.start_time AS [StartTime],

    ld.end_time AS [EndTime],

    ld.error_number AS [ErrorNo],

    ld.error_message AS [ErrorMessage],

    ld.command AS [Command],

    ld.succeeded AS [Succeeded]

    FROM

    msdb.dbo.sysmaintplan_plans AS s

    INNER JOIN msdb.dbo.sysmaintplan_subplans AS sp ON sp.plan_id=s.id

    INNER JOIN msdb.dbo.sysmaintplan_log AS spl ON spl.subplan_id=sp.subplan_id

    INNER JOIN msdb.dbo.sysmaintplan_logdetail AS ld ON ld.task_detail_id=spl.task_detail_id

    ORDER BY

    [StartTime] DESC

    Thanks
    Parthi

  • October 28, 2009 at 2:40 am

    #1071586

    Hi,

    Just for more troubleshooting can you create job with T-sql job steps to take backup and see whether that is working fnie.

  • October 28, 2009 at 10:48 am

    #1071911

    Hi parthi-1705

    thanks for the script

    those error messages are very long

    any way to break it out into say 40 charter lines so that it wraps and i can read it ?

    Thanks

    Jim

  • November 1, 2009 at 4:30 pm

    #1073638

    Fix by restarting SQL Agent and reload SSIS package

  • November 2, 2009 at 3:00 pm

    #1074022

    thanks for the script

    those error messages are very long

    any way to break it out into say 40 charter lines so that it wraps and i can read it ?

    You can change the output of SSMS to write to a text file instead of a table. That would probably make it easier for you to read.

    Joie Andrew
    "Since 1982"

  • November 2, 2009 at 4:23 pm

    #1074047

    Hi Joie

    actually i am using sqlcmd window and running it

    I am looking for a way to wrap a long column into readable 40 character widths and stay in the column

    Thanks

    Jim

  • November 2, 2009 at 4:45 pm

    #1074053

    Try running sqlcmd with the -w 40 paramater. That should wrap your text for you. You could also send the sqlcmd output to a text file. For more information, take a look at the sqlcmd help file.

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    Joie Andrew
    "Since 1982"

  • November 3, 2009 at 9:40 am

    #1074359

    Thanks Joie

    i will give it a shot

    Jim

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply