SQL Backup

All is explained in NBU for SQL Admin Guide: http://www.symantec.com/docs/DOC5173  

Have you tried to read through this guide? 

It is never a good idea to post questions in response to an article or blog. Only the author of the article gets notified of your post.
Always best to start a Forum discussion (as you have done here) if you have questions that you need to be answered. 

Here are some good tech notes ( older but the same info applies )

restore using the move script - http://www.symantec.com/docs/TECH51062

backup http://www.symantec.com/docs/TECH51059

In short the batch file is a script that is created in order to do a backup and restore.

In the batch file is a list of parameters that will specify the database and other options.

Like Marianne said, you should review the SQL Sysadmin guide as it goes into some of the terminology.

Hi All,

Could somebody tell me according to the Admin Guide "You can either execute the script immediately or save it to run later. You can run a script later by including it in the backup selections list of a backup policy" what does later mean here? Does it mean as below.

If we create a script and we dont execute it right now instead we choose run later. We add this script in the backup selection and we schedule it as a full backup at 8 PM everynight from Mon- Friday. Am i right this script would run at 8 PM everynight From Mon-friday as per schedule and what would happen if we delete the script in the mean time?

Pls reply

Hi,

One last question. Does full backup take all the backup including transaction log backup or we need to take trasantion backup seperatly?

Thanks,

Belse

No - transaction logs need a separate script. The manual explains how to backup transaction logs.

PLEASE read the manual!  (That is how I learned. And most of us on this forum.)