On Tue, 5 Mar 2013 15:59:58 +0100
Carlo Filippetto <carlo.filippetto AT gmail DOT com> wrote:

> as I write in the subject I need to backup Sql Server 2012, you have
> any idea on how to optimize the process and have a consistend DB
> 
> I thought to make a dump script and backup it, but how?
> Any other ideas?

Microsoft SQL Server has the "VSS writer" so you just have to enable VSS
for your backup job and then copy the database files (not transaction
log files though!) "as is" -- when the Bacula file daemon will enable
VSS on the requested volume(s), MSSQL server will flush any pending
changes to its database files and then the file daemon will copy them
from the shadow partition while they have consistent state.

You can see that VSS writer in the output of the
"vssadmin list writers" command run from the command prompt.

Another approach is to script running backups of the database files,
perform this script in the "[Client] Run Before Job", and then back
up the resulting backup files.

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users