Red Gate forums :: View topic - Combine sqb files
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Combine sqb files

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
agarg



Joined: 22 May 2012
Posts: 9

PostPosted: Tue May 22, 2012 4:24 pm    Post subject: Combine sqb files Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Thu May 24, 2012 3:41 am    Post subject: Reply with quote

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:
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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group