Forum Discussion

sudu_mlk's avatar
sudu_mlk
Level 5
16 years ago

Automatic Backups

Hi,

Any body can explain about the MS-SQL Server Policy?

And what is automaic backup and application backup?

----

sudarshan.

 

  •  Application Backup and Automatic Backup.

    A database backup requires an Application Backup schedule. You cannot
    perform backups if this type of schedule is not included in the policy. The
    database agent automatically creates this schedule, named
    Default-Application-Backup, when you configure a new database policy.

    You also need one or more automatic backup schedules if you plan to have
    NetBackup perform automatic backups, or if you use Snapshot Client features.

    ======================================================================

    SQL Server backup types
    Backup type Description

    Application Backup  
    The Application Backup schedule enables user-controlled NetBackup operations from
    the client. These operations include those initiated from the client and those initiated
    by an automatic schedule on the master server. NetBackup uses the Application Backup
    schedule when the user starts a backup manually. Configure at least one Application
    Backup schedule for each database policy. The Default-Application-Backup schedule is
    configured automatically as an Application Backup schedule.

    Automatic Backup
    An Automatic Backup schedule specifies the dates and times for NetBackup to
    automatically start backups. NetBackup runs the scripts in the order that they appear in
    the file list. If there is more than one client in the policy, the scripts are run on each
    client.


    ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290212.pdf
  •  Application Backup and Automatic Backup.

    A database backup requires an Application Backup schedule. You cannot
    perform backups if this type of schedule is not included in the policy. The
    database agent automatically creates this schedule, named
    Default-Application-Backup, when you configure a new database policy.

    You also need one or more automatic backup schedules if you plan to have
    NetBackup perform automatic backups, or if you use Snapshot Client features.

    ======================================================================

    SQL Server backup types
    Backup type Description

    Application Backup  
    The Application Backup schedule enables user-controlled NetBackup operations from
    the client. These operations include those initiated from the client and those initiated
    by an automatic schedule on the master server. NetBackup uses the Application Backup
    schedule when the user starts a backup manually. Configure at least one Application
    Backup schedule for each database policy. The Default-Application-Backup schedule is
    configured automatically as an Application Backup schedule.

    Automatic Backup
    An Automatic Backup schedule specifies the dates and times for NetBackup to
    automatically start backups. NetBackup runs the scripts in the order that they appear in
    the file list. If there is more than one client in the policy, the scripts are run on each
    client.


    ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290212.pdf
  • thanks for your usefull inforamtion.

    how this automatic backup will perform? is it full backup or backup only changes on the database like incremental?

    ----
    sudarshan
  • You don't specify Full or Differential backup of MS-SQL in the Netbackup schedule, rather that's done on the SQL Server side. 
  • Ok.

    when SQL-Application backup starts, we are seing several sql-database backup starts one by one and its completes.

    The situation when disaster occurs/ total database crashes, how we are going restore these database(full)
    .

    we generally on windows servers first restore last full backup and recent increamental, like this what is process on sql servers.

    thanks,
    sudarshan

  • Hi

    Please Find

    An application backup is a backup type that applies to all database agents clients

    An automatic backup is also an backup type that applies to all database agents client except netbackup to informix and oracle ..


    For oracle databse

    you can use automatic cumulative incremental and automatic cumilative diffrential


    Thanks