Can you backup a small SQL database with Symantec without an agent?

nevolved

We have Symantec Backup Exec v12.5 Server Suite, and need to back up a small (under 10GB) database and don't really want to purchase an agent.

Will we be able to without purchasing the agent? (Yes, I know it's probably not the best way)


Thank you!

brad-

I dont know if it has this option in it...but ive seen in acronis that you can issue command line prompts (to stop/start services in this instance) before and after the backup completes. If it has that option, then you can just just stop SQL service, run the script, backup, then start it back up.

If not, try the native backup. Its pretty easy.

sidsanders

is this msft sql or oracle? oracle you can backup to disk via rman and then use a standard remote agent to backup the file system (or backup to a share where you can back it up). similar for msft: create a maintenance plan and backup to disk --> follow the same logic for oracle.

blargoe

Just create a maintenance task in SQL Server and back up the database to the file system on the server, then back up the file with your normal nightly backup.

I never pay for the "database agent" for SQL Servers, SQL does a good enough job of backing itself up.

nevolved

Thank you!

astorrs

blargoe wrote: »

I never pay for the "database agent" for SQL Servers, SQL does a good enough job of backing itself up.

If you don't mind gigantic file sizes

I prefer to use Quest LiteSpeed for SQL backups and then take a standard backup of those files.

blargoe

Good point, but I have plenty of storage space so it's all good. His database is only 10GB.