On Mar 5, 2013, at 10:19 AM, John Drescher wrote:

> On Tue, Mar 5, 2013 at 9:59 AM, Carlo Filippetto
> <carlo.filippetto AT gmail DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users