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.
"