On Tue, 5 Mar 2013 15:59:58 +0100 Carlo Filippetto <carlo.filippe...@gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
