Forum Discussion

Martinstr's avatar
Martinstr
Level 2
14 years ago

AOFO + SQL

Hy Guys,   i have a question about using AOFO and SQL 2008 r2? We get the following Error:   Could i activate AOFO in the JOB for SQL? The Selectionlist for die HDD is " E:\SQL_Backu...
  • SaurabhK's avatar
    14 years ago

    Hello, You have SQL selected for backup from the volume drive, that is not how you backup SQL online. You need to install the SQL agent license, then backup from the "Microsoft SQL Server" selection and choose the databases. If you want to backup from the drive, you will need to either detach the datbase or stop the SQL SERVER service, which means that it will be an offline backup for you.

     

    In your case, you have the agent license installed, Please select the databases from under the "MICROSOFT SQL SERVER" option under the SERVER NAME in the selection list and rerun the with or without AOFO, by default, SQL 2008 R2 uses a VDI snapshot technology, so you do not need to enable AOFO on the job.

    Ensure that you have Backup Exec 2010 R2 and that the remote agent is also up to date.

     Also please refer to the below document and links within it to clarify any doubts about backing up SQL data.

    http://www.symantec.com/docs/HOWTO24055

     

    Please mark as solution if this helps resolve your problem