Sybase Administrative Commands: Everything You Need to Know

Sybase Backup Command for windows server envirement

SID :- S01
Backup Path :- G:/Backup/
tran :- For transaction Backup

USE the SAP TOOL and execute the below Command.

dump tran S01 to 'G:/Backup/S01_Tlog_2016-04-06.dmp' with compression = '101'
go
dump database S01 to 'G:/Backup/S01_Tlog_2016-04-06.dmp' with compression = '101'
go

Above mention command is for taking manual backup with destination path.

below mentions command is for tacking backup without defining destination path. it is tacking backup according to a backup template.

exec saptools..sp_dumptrans
exec saptools..sp_dumpdb

Scripts backup Command

exec saptools..sp_dumptrans P01
exec saptools..sp_dumpdb P01

Backup Restore command

use master
go
load database S01 from 'H:/dump/P01_db_2016-02-09.dmp'
go

Online database S01

Sybase Login Command

isql -Usapsa -SP01 -X
type password

Database Size increase command

Log Size

use master
go
disk resize name = "S01_log_001", size = "512M"
go
use master
go
alter database S01 log on Q01_log_001 = "512M"
go

Database Size

use master
disk resize name = "S01_data_001",size="32G"
go
alter database S01 on S02_data_001='32G'
use master
go

Transaction Log Enable or Disable Command

Transaction Log Disable

use master
go
sp_dboption S01, 'trunc',true
go
use S01
go
checkpoint
go

Transaction Log Enable

use master
go
sp_dboption S01, 'trunc',false
go
use S01
go
checkpoint
go