Backup/Restore of Sybase Database

In Sybase ASE 12.5.2, is it possible that a database backup can be split across 2 files? if so how can they be restored?
LVL 3
SingnetsvcAsked:
Who is Participating?
 
grant300Connect With a Mentor Commented:
If you look at the doc for "dump database....", you will see that you can specify "stripe on" multiple times.  Each time points to a dump device, either implicit or explicit.  You are probably using implicit dump devices; that is you just specify the file name you want the dump to go to.

There is another option to do compression as well which can reduce your headaches if you are bumping up against a 2GB file size limitation or simply don't have enough disk space.

Finally, the "restore database" command allows you to specify multiple "from" files which is how you get the whole thing back into the database.

Dump Database doc is here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36272_1251/html/commands/title.htm&toc=/com.sybase.help.ase_12.5.1/toc.xml

There is also a great deal of information about backups and recovery procedures in the Admin manual, here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36272_1251/html/commands/title.htm&toc=/com.sybase.help.ase_12.5.1/toc.xml

Regards,
Bill
0
 
SingnetsvcAuthor Commented:
Using load database with stripe parameters seems to have worked.
0
All Courses

From novice to tech pro — start learning today.