UNSOLVED

davidto1

updated

12 years ago

D

davidto1

1 Message

0

2501

May 15th, 2014 19:00

Does Avamar backup database files by default?

Does anyone know if you have a db on a server, and run file level backups on it, do the db files get included? Say .sql files for ex.

  • SuhelaDighe

    1 Rookie

    •

    70 Posts

    1153

    0

    Posted May 16th, 2014 04:00

    I moved this discussion to the Avamar Support Forum.

  • J_H_

    2 Intern

    •

    498 Posts

    1153

    0

    Posted May 19th, 2014 15:00

    it will try to backup a db file like *.ldf *.mdf *.ndf  (sql database files) but might not be able to depending on open file

    BUT you cannot really backup and/or restore a running database with a filesystem backup.

    I exclude my database files from the backup and let the proper DATABASE backup get that.

    but you don't have to and should not take my word for it.

    Browse your backups - see if it has the db files - and I would exclude them to save space and time - as you cannot do anything with them.


  • pp082c

    38 Posts

    1153

    0

    Posted August 28th, 2014 05:00

    Hi

    running only a file level backup on a DB server does not include the db files in the backup.

    RMAN as for Oracle does the DB file backup/restore activities.


    I totally agree with J.H, here is what we exclude in our environment to save time and run good backups.


  • Leo Li

    4 Apprentice

    •

    9030 Posts

    1153

    0

    Posted September 1st, 2014 23:00

    Absolutely, the DB files does not included if run the file level backup. Please use Avamar plugin for database to backup database. SQL plugin for SQL DB, Oracle plugin for Oracle DB etc.

    Please refer to Avamar Administration Guide and Avamar Backup Clients User Guide