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

nevolvednevolved Posts: 131Member
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!

Comments

  • brad-brad- Posts: 1,218Member
    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.
  • sidsanderssidsanders Posts: 217Member ■■■□□□□□□□
    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.
    GO TEAM VENTURE!!!!
  • blargoeblargoe Self-Described Huguenot NC, USAPosts: 4,171Member ■■■■■■■■■□
    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.
    IT guy since 12/00

    Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
    Working on: RHCE/Ansible
    Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands...
  • nevolvednevolved Posts: 131Member
  • astorrsastorrs Posts: 3,139Member ■■■■■■□□□□
    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.
  • blargoeblargoe Self-Described Huguenot NC, USAPosts: 4,171Member ■■■■■■■■■□
    Good point, but I have plenty of storage space so it's all good. His database is only 10GB.
    IT guy since 12/00

    Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
    Working on: RHCE/Ansible
    Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands...
Sign In or Register to comment.