Allow me to reply since you dont appear to be being listened to by the employees that have been writing you.
Yes.
Since it is your file server, you will undoubtedly have open files at some point.
Therefore you will need an AOFO on the BUE server.
I am unsure if the BUE server can backup its own SQL DB without a SQL agent, (Which would be insane if it couldnt).
But perhaps Veritas feels that since its using SQL DBs then they can get a slam dunk SQL agent sale by using SQL for thier own product and not allowing its backup automatically.
(This is merely speculation however.)
If they require you to buy an SQL Agent for the BEU server, then I would use a tool to stop the SQL server, copy the dir that contains the sql tables and then restart the service a few minutes BEFORE the backup begins.
Just script it.
I do this on ALL DBs that i can.
SQL servers have a tool built in to take snapshots of the databases while online and you can back the snaps without an agent of any kind.
Agents at the very lest, speed up communication.
But if you have a gigabit dedicated seperate network with two NICs in each server, one for production and the other for the backup server, and have no open files or open DBs to deal with, then I say forget using agents completely.
It would be a wast of money to buy them then.
If you set it up that way, you get it all.
You get speed and the files without argument and dont even bog the production network down!Message was edited by:
burnsl