Local disk backup through NetBackup for SQL Server

[Kunalgoel]

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.

[Gurvinder]

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]

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]

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

[Kunalgoel · Accepted solution]

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

[Gurvinder · Accepted solution]

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.

"

[Marianne]

@Kunalgoel 

Are you using NetBackup or Backup Exec?

You have posted NetBackup question in BE forum?