Back up failures!! urgent!! plz

  • SQL 2000 back up fails and does not back up any database,

    it starts working after restarting the server?

    it also states that downgrading back up buffer from 960K to 64 K

    Any solution Please.!!

    Thanks

  • Probably problem with Sql Server Agent.

    Most of the time Stop and Start of Agent clears issues such as this one.

    Hope this helps,

     

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • First a few questions:

    • Are you running backups through the SQL Agent ?
    • Is your backup performed via a SQL Maintenance Plan or your own TSQL ?
    • Can you post the exact error output ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

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