No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
MENU

FAQ-How to Back Up A Database with the Data Size of More Than 2 GB

Publication Date:  2012-07-25 Views:  12 Downloads:  0
Issue Description
Q:
When you back up a database with the data size of more than 2 GB, the following error may occur:
I/Oerror:
operating system error,server device /backup/data. code 27 messages
file too large. 
 
Alarm Information
Null
Handling Process
A:
This error occurs when the size of backup file is more than the maximum file size limited by the OS. Some OS does not support the file of more than 2 GB in size. In this case, you can back up a database to more files through the Backup Server. Take the database pubs2 as an example:
1>dump database pubs2 to "/usr/sybase/pubs2_dump.1"
2>stripe on "/usr/sybase/pubs2_dump.2"
3>stripe on "/usr/sybase/pubs2_dump.3"
4>go
This method can also improve the backup and restoration speed. Note that the restoration also requires as many devices as for backup. For example:
1>load database pubs2 from "/usr/sybase/pubs2_dump.1"
2>stripe on "/usr/sybase/pubs2_dump.2"
3>stripe on "/usr/sybase/pubs2_dump.3"
4>go 
 
Root Cause
Null
Suggestions
Null

END