Archiving SQL Server Logs...??

  • Hi Folks

    I need to know that how can archive sql server logs....for example if i want to archive log file (information) for current date or specific date...

    Please help...

    Thanx in advance..

    SqlIndia

  • You want to archive the SQL Server log files for a database, or the error and sql agent logs?  The log files aren't "archivable" per se, but you can perform log backups, etc.  Is that what you are looking for?

    If it's the error and SQL Agent logs, you will need to write something for that.  It would just be a matter of monitoring the directories and copying files as they roll over, or as you reach certain time thresholds.  Why wouldn't you just use a backup program though?

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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