SQL Backup

[belse]

Hi All,

Could somebody explain the role of batch file The script that is used to back up or to restore SQL Server objects.

My last question in the below link is still unanswered. Could somebody help here pls.

https://www-secure.symantec.com/connect/articles/how-backup-and-restore-microsoft-sql-server-backup-...

[Marianne]

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. 

[Dyneshia]

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.

[belse]

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

[Marianne · Accepted solution]

Your assumption is correct. If you add the script to Backup Selection, the script will run on the client as per the Automatic Backup schedule.
You need to keep the Application Backup Schedule that is created by default. It allows the user directed backups started by the script.

If you delete the script on the client, the scheduled backup will fail with status 2.

[belse]

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

[Marianne]

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