Restoring a DB backed up via SQL Back without SQL back

Compresses, encrypts, secures and monitors SQL Server backups.

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

Restoring a DB backed up via SQL Back without SQL back

Postby EdCarden » Tue Dec 04, 2012 11:14 pm

If I back up a database to multiple files using SQL back (so as to create several smaller files instead of 1 giant bak file) and then move those files to another SQL Server do I have to use SQL Back to restore the DB that is spread across those multiple files?
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm

Postby petey » Wed Dec 05, 2012 2:21 am

You will need to use SQL Backup if you want to restore directly from those files.

The alternative is to first convert those files to native SQL Server backup files using the SQBConverterGUI or SQBConverter applications (found in the SQL Backup installation folder), then use SQL Server to restore using those converted files.
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

Re:

Postby EdCarden » Thu Dec 06, 2012 6:38 pm

petey wrote:You will need to use SQL Backup if you want to restore directly from those files.

The alternative is to first convert those files to native SQL Server backup files using the SQBConverterGUI or SQBConverter applications (found in the SQL Backup installation folder), then use SQL Server to restore using those converted files.



Thanks Petey. BTW - I did try and find this info first but could not. Is this restriction mentioned naywhere in the SQL Back documentation? What about any mention of the 2 applications you mentioned, SQBConverterGUI & SQBConverter ?
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm

Postby petey » Sat Dec 08, 2012 2:36 am

I don't know if this 'restriction' is mentioned anywhere in the documentation. If you need a version of SQL Backup to only restore databases, you could contact the Red Gate sales department for options.

With regards to the conversion applications, it's under 'Tools & Utilities > SQL Backup File Converter'.
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