Windows Image Backups of Large SQL dbs

This forum is no longer monitored by the BackupAssist support team, but is available to the public to use for assistance with technical issues relating to BackupAssist v5.x.x.

Moderators: casey.burns, Stuart, michael.jones, gsohal, Mike D

Windows Image Backups of Large SQL dbs

Postby argus » Fri Oct 07, 2011 1:09 am

One of the reasons we are using Backup Assist is so we can do the block level backups of large SQL databases.

Doing in-SQL backups or raw file copies takes 17-24 hours because of the size of our database (half terabyte) and the slow speed of our external drive to which we are backing up.

The hope was that switching to image backup would backup just the changed data...but that is still taking 17-24 hours. The db is half a terabyte, but only a few GB of data changes between backups, so we would think that a block level solution would backup just the few GB that has changed.

What are we doing wrong here?

using BA 5.4.6

I can export the settings of the Backup Job in question...if that can be done somehow?
argus
User
 
Posts: 1
Joined: Fri Oct 07, 2011 12:59 am

Re: Windows Image Backups of Large SQL dbs

Postby Stuart » Thu Dec 22, 2011 12:52 pm

Hi Argus,

It's Stuart here from the BackupAssist team, thanks for posting on our forum.

Unfortunately BackupAssist (the SQL add-on and Windows imaging engine specifically) does not do block/delta level copies of database files. You could perform a transactional backup using the SQL add-on; however this will perform a full backup at the end of each day. The Windows imaging engine is able to perform incremental backups of files; however if the file has changed then the entire file is copied as part of the backup.

If you're wanting to perform this type of backup, then you may wish to look into performing an Rsync backup as this does go to the bit level and copies only the changed sections of the file.
More information regarding this engine can be found by visiting http://www.backupassist.com/BackupAssist/tour_Rsync.html.

If you have any further questions; please feel free to reply to my post or contact our support team.
Stuart
Cortex I.T.
 
Posts: 998
Joined: Tue Sep 02, 2008 2:25 pm

Re: Windows Image Backups of Large SQL dbs

Postby berrybreet » Tue Jan 20, 2015 9:28 pm

this is very nice post :D
berrybreet
User
 
Posts: 1
Joined: Tue Jan 20, 2015 9:26 pm


Return to Technical Support v5

Who is online

Users browsing this forum: No registered users and 4 guests

cron