Bacula-users

Re: [Bacula-users] Best way to perform a backup for Sql Server 2012

2013-03-07 02:30:06
Subject: Re: [Bacula-users] Best way to perform a backup for Sql Server 2012
From: James Harper <james.harper AT bendigoit.com DOT au>
To: James Harper <james.harper AT bendigoit.com DOT au>, Dan Langille <dan AT langille DOT org>, Carlo Filippetto <carlo.filippetto AT gmail DOT com>
Date: Thu, 7 Mar 2013 07:27:10 +0000
Also one very important thing to not about mssql server if you start doing diff 
and inc backups - diff and inc backups are based on the most recent normal 
backup taken.

If someone does a backup external to your automated Bacula backups, future diff 
and inc backups are based from that one, not the one Bacula did, and if that 
backup gets put somewhere that Bacula doesn't back up, or deleted, you will be 
unable to use your future diff and inc backups to restore from.

If you want to do a backup outside of Bacula, use the WITH COPY_ONLY option to 
ensure that the backup sequence isn't interrupted.

James

> -----Original Message-----
> From: James Harper [mailto:james.harper AT bendigoit.com DOT au]
> Sent: Thursday, 7 March 2013 5:54 PM
> To: Dan Langille; Carlo Filippetto
> Cc: bacula-users
> Subject: Re: [Bacula-users] Best way to perform a backup for Sql Server 2012
> 
> > >
> > > 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

------------------------------------------------------------------------------
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