Author: Carlo Filippetto <carlo.filippetto AT gmail DOT com>
Date: Tue, 5 Mar 2013 15:59:58 +0100
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? A
Author: John Drescher <drescherjm AT gmail DOT com>
Date: Tue, 5 Mar 2013 10:19:44 -0500
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
Author: Konstantin Khomoutov <flatworm AT users.sourceforge DOT net>
Date: Tue, 5 Mar 2013 19:20:53 +0400
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 daemo
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
Author: James Harper <james.harper AT bendigoit.com DOT au>
Date: Thu, 7 Mar 2013 06:54:17 +0000
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
Author: James Harper <james.harper AT bendigoit.com DOT au>
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 exter