cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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.

 

Tags (2)
2 Solutions

Accepted Solutions
Highlighted
Accepted Solution!

Re: Local disk backup through NetBackup for 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

View solution in original post

Highlighted
Accepted Solution!

Re: Local disk backup through NetBackup for SQL Server

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.

"

View solution in original post

6 Replies
Highlighted

Re: Local disk backup through NetBackup for SQL Server

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.

Highlighted

Re: Local disk backup through NetBackup for SQL Server

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?

Highlighted

Re: Local disk backup through NetBackup for SQL Server

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

Highlighted
Accepted Solution!

Re: Local disk backup through NetBackup for 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

View solution in original post

Highlighted
Accepted Solution!

Re: Local disk backup through NetBackup for SQL Server

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.

"

View solution in original post

Highlighted

Re: Local disk backup through NetBackup for SQL Server

@Kunalgoel 

Are you using NetBackup or Backup Exec?

You have posted NetBackup question in BE forum?