| Author |
Message |
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
 Posted: Tue Dec 04, 2012 11:14 pm Post subject: Restoring a DB backed up via SQL Back without SQL back |
 |
|
| 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? |
|
| Back to top |
|
 |
petey
Joined: 24 Apr 2005
Posts: 2216
|
| Posted: Wed Dec 05, 2012 2:21 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
| Posted: Thu Dec 06, 2012 6:38 pm Post subject: Re: |
|
|
| 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 ? |
|
| Back to top |
|
|
petey
Joined: 24 Apr 2005
Posts: 2216
|
| Posted: Sat Dec 08, 2012 2:36 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
|
|
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
