Networks

Ask something
Question Locked

Symantec Advanced open file option

0 helpful
4 replies

by unimaker2000

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are planning to purchase the AOFO for our file servers, but I don't know if we need it for our MS SQL server, I heard that there is a specific agent for this. So if we buy the agent does that mean we don't need the AOFO to backup the SQL server properly?
Please advise.

4 replies

by bart777

The SQL agent is a different license. You wouldn't need to AOFO but this will be used for other open files on the server.

by unimaker2000

Thank God for that coz the AOFO is not cheap! The computer we have only runs MS SQL server and nothing else, so we only need the agent and NOT the AOFO, yes? Sorry to be a pest by double checking!
On the other hand, instead of the above, how about using the enterprise manager to backup to disk then save it to the backup server and then back it up as normal? Will this be a good alternative than paying loads for the licenses?

by debasish_jaiswal

If you need to back up the SQL database you do not need to get the AOFO licence. AOFO is for backing up files which are in open state and not for database backups.

Databases like SQL & Exchange do not need the AOFO, and also if you have the licence for botht eh SQL and AOFO, please do not use the AOFO when backing up the SQL as then it will be a file leavel snap shot backup, and will be very dificult to restore from.

If you may have any further doubts, polease let me know

Regards
Deb Jais
Microsoft Certified Professional
Symantec Certified Specialist

This discussion is closed to new replies.