Combine sqb files

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Combine sqb files

Postby agarg » Tue May 22, 2012 4:24 pm

Hi,
We use RedGate backup tool for our sql server database backups. Have couple of questions:

1. I split the backup into multiple files. Is there a way to combine those multiple backup files into just 1 file later? I have 20 sqb files for the same database backup - how to combine them into just 1 sqb file if needed?

2. Currently, I have to specify how many files I need the backup to be split into, and I have to give the file names. But I want the number of files to be dependent on the backup size. That is if the backup size is 10gb, then split it into 20 files, if it is 15gb, then 30 files - something like that. In a way, I want the backup file size to be fixed, say at 500mb. Is it possible? Also, can I just specify a naming convention for the backup files instead of specifying all the file names literally?

Thanks.
Ajay
agarg
 
Posts: 9
Joined: Tue May 22, 2012 4:10 pm

Postby petey » Thu May 24, 2012 3:41 am

No, there isn't a way to combine multiple files of the same backup set into a single file.

No, there isn't a way either to split a backup set into files of equal sizes.

With regards to the naming convention, you use enter a base name and use the FILECOUNT option e.g.

Code: Select all
EXEC..master..sqlbackup '-sql "BACKUP DATABASE AdventureWorks TO DISK = [g:\\backups\\AdventureWorks.sqb] WITH FILECOUNT = 5"'

will split the backup set across 5 files with the following names:

g:\\backups\\AdventureWorks_01.sqb
g:\\backups\\AdventureWorks_02.sqb
g:\\backups\\AdventureWorks_03.sqb
g:\\backups\\AdventureWorks_04.sqb
g:\\backups\\AdventureWorks_05.sqb
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests