Beta Draft Confidential
Backup Procedures
Subsequent Backups to the Local Backup Server
B-STDX, CBX, and GX Network Management Station Installation Guide
7/12/04
7-5
5.
Press <Ctrl> and D to stop the script command.
6.
Check for errors in the file
/opt/sybase/backup/sybck.out
.
7.
Initiate an isql session by entering:
isql -U sa -P <
SA password
> -S <
database server name
>
8.
Save the transaction log by entering:
1>
dump transaction cascview to
“/opt/sybase/backup/transbackup.<
Date
>”
2>
go
The
<Date>
refers to today’s date in MM-DD-YY format.
9.
Save the master and cascview databases by entering:
1>
dump database master to
"/opt/sybase/backup/masterbackup.
<Date>
"
2>
go
1>
dump database cascview to
"/opt/sybase/backup/cascbackup.<
Date
>"
2>
go
1>
quit
The
<Date>
refers to today’s date in MM-DD-YY format.
The backup procedures now require you to bulk copy out your Sybase database.
10.
If you do not have a directory to save the bulk copy files, create a directory by
entering:
mkdir /opt/sybase/backup/storedb
11.
Bulk copy the database to the
storedb
directory by entering:
/opt/CascadeView/bin/cv-copydb.sh out cascview
<
SA user password
> /opt/sybase/backup/storedb
For example,
<
SA user password
>
could be
superbase
.
Note –
If you encounter errors when you perform the
dbcc checkdb
command, do
not proceed any further and call the Technical Assistance Center. See
“Technical
Support”
on
page xviii
.
