How can I backup an sql database

[Ialahmad]

Hi all;
How I can backup an sql 2000 Database via netbackup 6.5 ,, how I configre policy to perform backup ,,, I  see backup job has  backup selected  this file
 SQL_MONTHLY_FULL_BACKUP.bch

OPERATION BACKUP
DATABASE $ALL
SQLHOST "ESTARTA"
NBSERVER "MASTER"
STRIPES 2
MAXTRANSFERSIZE 0
BLOCKSIZE 7
POLICY DMZ_MEDIA_SQL_ESTARTA_MONTHLY
ENDOPER TRUE


Please any help and more clear this file content.

kind regards.

[Anonymous · Accepted solution]

Reference this NetBackup guide
Microsoft SQL Server System Administrator's Guide (  http://seer.entsupport.symantec.com/docs/290212.htm )

Configuration of full database backups with NetBackup 5.x for Microsoft SQL Server
http://seer.entsupport.symantec.com/docs/273205.htm

Configuration of VERITAS NetBackup (tm) 5.0 for SQL Full backups Using the Batchsize Parameter
 http://support.veritas.com/docs/273201

Configuration of NetBackup 5.0 for SQL Full backups Using the Stripes Parameter
 http://support.veritas.com/docs/273203

Configuration of VERITAS NetBackup (tm) 5.0 for SQL Transaction Log Backups
 http://support.veritas.com/docs/273210


Although for 5.x should apply similarly to 6.5

[David_McMullin]

Be aware that stripes and blocksize can overload a windows system and cause the backup to fail, and since there is no memory, windows DOES NOT ISSUE AN ERROR CODE

Windows SQL backups MUST be monitored to ensure they complete, since jobs can complete with status 0, but only back up a portion of the $ALL Databases!!!!

[Insplre85]

Since you have created the SQL batch file , just proceed to create policy , application backup

Should have default & full . Sent the file to backup to the batch file on the SQL server.

Make sure the account that you use to run the NBU service on SQL have the right as admin & able to peform RUN job as batch file (System Policy) .

With this m you should be able to drive it..

[Zahid_Haseeb]

Try this

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

[MariusD]

try this:

OPERATION BACKUP
DATABASE $ALL
SQLHOST "your SQL host name"
NBSERVER "your NBU Master host name"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

With this script I back up my SQL database.

[Ialahmad]

Many  Thank to All backup policy run.