On Mar 5, 2013, at 10:19 AM, John Drescher wrote: > On Tue, Mar 5, 2013 at 9:59 AM, Carlo Filippetto > <carlo.filippe...@gmail.com> wrote: >> Hi all, >> 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? >> >> Thank you. >> > > 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. -- Dan Langille - http://langille.org ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
