Forum Discussion

Kunalgoel's avatar
Kunalgoel
Level 4
6 years ago

Local disk backup through NetBackup for SQL Server

Hi Team,

we are performing SQL backup through "native SQL server backup" on one file server. 

And from file server sql backup is going to tape as a normal file system backup.

If any disaster happenend and need restore and there is no data on file server , can we restore directly from tape to sql server? or need to restore first on file server and from there SQL guy restore it on SQL server.

 

  • Thank you Gurvinder... but if we are taking backup through sql agent and backup is getting backed up on tape... so we can directly restore SQL db without intervention of SQL admin

  • yes, if you are taking backup using the SQL agent , then you can restore straight back to the sql server w/o intervention from admin.

    My answer in thread above is for your post which reads as

    "performing SQL backup through "native SQL server backup" on one file server. 

    And from file server sql backup is going to tape as a normal file system backup.

    "

  • from backup exec perspective since you are backing up flat files from X server, you can redirect restore to Y server (which is your sql server) and then have the admin restore it to sql instance from there.

    • Kunalgoel's avatar
      Kunalgoel
      Level 4

      Hi Gurvinder,

      Lets suppose 

      Server "A" is a sql server and its getting backed up on file server through native sql server. And from file server through Symantec backup exec its backed up as a normal flat file backup on tape.

      suppose DB got crashed and SQL team needs restore and data is expired from file server, so can we directly restore it on server "A" from tape and then SQL admin restore it to sql instance?

      • Gurvinder's avatar
        Gurvinder
        Moderator

        yes, as long as you have an BE remote agent installed on the database server, you can run a redirected restore to restore the tape backup backed up from file server to database server and then have your admin restore it to SQL