03-11-2019 02:04 AM
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.
Solved! Go to Solution.
03-11-2019 02:29 AM
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
03-11-2019 02:37 AM
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.
"
03-11-2019 02:11 AM
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.
03-11-2019 02:19 AM
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?
03-11-2019 02:25 AM
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
03-11-2019 02:29 AM
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
03-11-2019 02:37 AM
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.
"
03-11-2019 04:19 AM
Are you using NetBackup or Backup Exec?
You have posted NetBackup question in BE forum?