Forum Discussion

Rob_Dullaart's avatar
Rob_Dullaart
Level 5
9 years ago

MS SQL backup

environment: Windows 2008 R2 with Netbackup 7.6.0.2

I am implementing MS SQL backups. At the moment I installed the agent on one of our test servers. Also there is a policy configured to backup the entire database. Together with our DBA I succeeded to make a backup.

So all goes well actually. However our DBA's need to get familiar with the tools and start to have confidence in Netbackup. 

In the past I worked with Oracle DBA's and they can do backups and restores with RMAN. That interacts with Netbackup. Is there something like that for MS SQL? Can the MS SQL DBA's use their tools to have interaction with Netbackup? Or can they just use the Netbackup tools? 

7.6
Agents
Backing Up
Backup and Recovery
Configuring
Documentation
Evaluating
NetBackup
Restore
Windows Server (2003-2008)
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    9 years ago

    If you prefer DBA based control of scheduling, refer to chapter

    "Performing user-directed operations with dbbackex"

    in Microsoft SQL Server Administrator's Guide.

    Michal

     

     

     

7 Replies

Sort By
Replies have been turned off for this discussion
  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    The NBU for SQL GUI on the SQL server is the only interface to be used to backup, restore, or to create backup or restore scripts.

    The NBU for SQL GUI makes SQL the easiest database to implement - for NBU admins and dba's.

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    9 years ago

    Hello,

    agreed, you cannot use for example SQL Server Management Studio or native MS SQL commands to backup/restore to/from NetBackup.

    Michal

  • Rob_Dullaart's avatar
    Rob_Dullaart
    Level 5
    9 years ago

    Ok thanks for the quick answer, then I have to teach our DBA's. 

    Can they schedule their backups from the NBU GUI on the database server? I don't want to give them access on the master server or on the Netbackup Admin Console. 

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Nope. Same as Oracle or any other db backup.

    Creating Policies and backup scheduling can only be done from NBU Admin console on a master or media server. Or from Windows Admin Console on a Windows desktop that has been added to SERVER entries on the master.

    Or from NBU Java Console with neccesary permissions for the relevant user in auth.conf.

  • Rob_Dullaart's avatar
    Rob_Dullaart
    Level 5
    9 years ago

    But what I meant what the Oracle DBA's did is they scheduled or started their backups with Oracle Grid Control, Oracle Grid control started an RMAN script and that initiated the backup. 

    What I am looking for now is something simulair for MS SQL.

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Let your SQL dba's create the scripts and let you know the location and name of script, when to run the backup and the retention.

    Create a policy to automate the backup.

    That is how most environments run their SQL backups.

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    9 years ago

    If you prefer DBA based control of scheduling, refer to chapter

    "Performing user-directed operations with dbbackex"

    in Microsoft SQL Server Administrator's Guide.

    Michal