October 8, 2012 at 11:51 am
Hey fellow SQL DBA's!
Here's something I have been researching -
I am trying to create a backup job that will specify a backup size, and once the backup reaches that size it automatically splits the backup. Splitting the backup up is easy enough. But we want the job to manage the backups so that as the size of the backups increase, it automates splitting it further (adding another file) so that they never get beyond a specified size.
Super Ninja Pirate DBA team GO!
October 8, 2012 at 1:55 pm
LOG, FULL or DIFF?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:56 pm
FULL backups.
Nice catch!
October 8, 2012 at 2:53 pm
So the question really is:
How do I estimate the size of my FULL backups so I can predict when I should add another backup device? :Whistling:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:58 pm
I want it all automated bro!
I want to say:
(automatically) estimate the backup size of this database and split it up so that each backup portion is never bigger than (let's say) 10 GB. That way as the database (and backups) continue to grow in size, the job adjusts accordingly without mu intervention.
October 8, 2012 at 3:21 pm
kingrudedog (10/8/2012)
I want it all automated bro!I want to say:
(automatically) estimate the backup size of this database and split it up so that each backup portion is never bigger than (let's say) 10 GB. That way as the database (and backups) continue to grow in size, the job adjusts accordingly without mu intervention.
I know. What I am saying is that the only way to know how big a backup will be is to take it. So, you can look at the last backup size and decide when to split. Or, you could look at the database stats and factor in compression to try and get an estimate of how much data will be backed up and what size your backup file will be.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply