Need Sybase Database Backup Program

[Muwafaq]

Hi all,

We, as users of the financial sector, started using Sybase10 version. Sybase database is a client / server mode, the basis of distributed processing architecture, a sound security performance, high-speed and efficient operation mode, multi-platform, cross-operating system widely used in etc., was quickly accepted and promote the use of IT sector. In the specific use, found in a centralized data management has its merits, that is, the scope of the data greatly reduced risk, but as a Sybase server side, the data are relatively concentrated risks, I want to know that how to do a database backup in Sybase. Please advice. Thanks in advance.

[kelfro]

Using Sybase's Backup Server, do a backup Dump. Dump database (Dump database), is for the entire database (including data, table structures, triggers, cursors, stored procedures, transaction logs, etc.) do a physical backup. Dump database, the system automatically performs a checkpoint, about to log and data copied from the buffer to the hard drive, has been assigned to the page dump to the device. Command format is:
dump database database name to device file name with parameters

stripe on device file name 2
stripe on device file name of three with parameters

[Katty]

The data backup is to run the entire database environment, a complete copy, including database of dirty pages and fragments, using the load command to restore, only to return to the same size of the database (data and log size of the only energy and had exactly the same), applies to business outlets end of the day every day after work daily backup. Advantage is that complete and accurate database, the disadvantage of not directly view the contents of the backup. Check and reply

[Praetor]

In the windows platform, Sybase SQL Server Manager (database management) platform, select ServerGenerate ddl is generated throughout the database server all of the information, if you select databasegenerate ddl is generated by the selected information in the database in order to master database, for example, the resulting documents include : config.ddl (configuration), devices.ddl (equipment), database.ddl (database), logins.ddl (the user), remote.ddl (remote), cache.ddl (buffer), segment.ddl (), group . ddl (User Groups), user.ddl (the user), default.ddl (do Province), rule.ddl (rules), udt.ddl, table.ddl (table), view.ddl (view), proc.ddl (stored procedure), triger.ddl (trigger). All the best.

[MindSpace]

Sybase database tables in order to self-generation bulk copy tool to guide the way into a certain format text file, the command format:bcp table out the path name of the file name-c-t separator-u (user name)-p (password)-S (server name). If a database all the tables are doing a bcp backup, you need a table for each are doing a bcp, under normal circumstances, a database has more than 100 tables, the workload is relatively large. Can use the information in the database system table bcp to do a backup of the script. Principle is that each user has a table of information in the system table records, you can get isql statement query. To give one example:
(1), first edit a file named mkbcpout.sql file reads as follows:

select "echo bcp '" + name + "out ... ... ... ... ... ... ... ...'
"+" bcp "+ name +" out. / + "name +". table-c-t '|'-Uuser-Ppassword-S SERVER "from sysobjects where type = 'U'
go

[opaper]

You can also use a script to do a backup method of doing bcp database defragmentation. Sybase database as the online transaction processing application server, database every day applications are doing a lot of insert, modify, and delete operations, the inevitable physical storage media in the database page on the left and expand cell debris fragments, thus affecting the database storage efficiency and speed. Specific indications were: Deadlock occurs when busy (dead lock), a database input / output resources are a large number of occupation, business processes slow.The solution is clear all the tables in the database, the command format is :

isql-Uusername-Ppassword-I truncate.sql-o error.truncate