Forum Discussion

be-nugget's avatar
be-nugget
Level 5
12 years ago

Backup Exec - SQL Agent Backups

Hello, just wanted confirmation on something and ultimately best practice.

If you want to backup a SQL server and are licensed to use the SQL agent, and select to use the 'Microsoft SQL Server' option in the selection list, which SQL files are you safe to remove from the selection list under the MSSQL\DATA folder for that server is it just the MDF and LDF files?

Thanks

12.x and Earlier
Backing Up
Backup and Recovery
Backup Exec
Best Practice
Tip-How to
Windows Server (2003-2008)
  • CraigV's avatar
    CraigV
    12 years ago

    Hi,

     

    BE's Active File Exclusion would automatically ignore the *.mdf and *.ldf files as things go.

    You can put them in as exclusions or just let AFE do it's job.

    Thanks!

  • CraigV's avatar
    CraigV
    Moderator
    12 years ago

    Hi,

     

    BE's Active File Exclusion would automatically ignore the *.mdf and *.ldf files as things go.

    You can put them in as exclusions or just let AFE do it's job.

    Thanks!

  • be-nugget's avatar
    be-nugget
    Level 5
    12 years ago

    Cool if AFE does the job then thats cool - be good if it actively greyed out those files in the selection list viewer so you knew that.