mps during periods of normal load, although performance would be affected.
How do I back up to tape using isql?
Log in to isql and issue the following:
1> dump database <dbname> to "<devicename>" 2> go
You can save and execute this script through an automated scheduler such as cron, if you know that your dump tape will be in that particular tape drive when the scheduler job executes. Otherwise, you risk overwriting the wrong tape.
For larger databases, you may have to stripe across several tape drives to perform this automatically. For information on striping, see the Sybase Adaptive ServerTM Enterprise System Administration Guide
When should I perform checkpoints, or does the server automatically perform checkpoint before a backup?
Adaptive Server checkpoints the databases automatically at the beginning of dump command. At other times, checkpoint frequency is controlled by the "recovery interval" parameter (sp_configure) and the amount of activity in the database. Otherwise, perform a manual checkpoint after making direct updates to system tables and as part of changing parameters with sp_dboption.
Why did my backups stop working after upgrade?
Unless the Backup Server is correctly defined, it cannot run. This often occurs when users rename the Backup Server from the default name. To determine whether this is your problem, run the following isql statement:
1> select * from master..sysservers 2> go
If the srvnetname column does not list the name you use for your Backup Server, change it by performing one of the following:
Create an alias in your Backup Server RUN_SERVER file
-S<your_backup_server_name> Modify the network name in the interfaces file using the installation utility for your platform.
Use sp_addserver to update the network name for SYB_BACKUP.
1> sp_dropserver SYB_BACKUP 2> go 1> sp_addserver SYB_BACKUP, null, <your_backup_server_name> 2> go