> >
> > I would use the T-SQL  backup command to backup the sql database to a
> > file then have bacula backup that file. I have tried scripting dumps
> > however it seems that the T-SQL BACKUP / RESTORE works better than the
> > management studio scripting to .sql ( at least in my testing).
> 
> 
> What he said.
> 
> I'm a big fan of dumping to text, backing up that text.
> 
> To be sure, copy that text to another server, then load that DB up and see
> how it goes.  I do that every day for every database I backup.
> 

What I do is:

. Full backup once a week
. Diff backup once a day
. Log backups hourly (done completely separately of backup)

The full and diff backups are done via an SQL script that enumerates all 
databases and backs them all up. I don't have a way of excluding backups at 
this time.
After each full backup runs:
Restore a copy of master, model, and msdb to an alternate location then detach

The last step is done because you need master, model, and msdb in place to 
bootstrap mssql so having these present is really useful.

I can post scripts but would need to redact them first :)

James



------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users