怎样在sybase中建立设备及数据库，请给出详细命令，谢谢

[scbb2001]

急急

[lalakill123]

最好直接用工具ssm或者sybase central

[scbb2001]

没有人帮帮我吗

[mnlsdyl]

/**if not exist follow device_no then continue***/
sp_configure "number of devices",20
go
reconfigure
go

set nocount on
go
use master
go
/********* 1 size=2K ******** 512 size=1M *********/
/******* 5120 size=10M *** 512n size= nM *********/
disk init
name ="data",
physname ="/vol/data.dat",
vdevno =7,
size =768000
go
disk init
name="index",
physname="/vol/index.dat",
vdevno=8,
size=204800
go

disk init
name="log",
physname="/vol/log.dat",
vdevno=9,
size=307200
go
PRINT 'Creating the "DB" database'
go
create database DB on
data=1500,
index=400
log on log=600
go

use DB
go
execute sp_addsegment indexsegment,DB,index
execute sp_dropsegment "default",DB,index
execute sp_dropsegment system,DB,index
go

sp_dboption DB,"trunc log on chkpt",true
go
use DB
go
checkpoint
go
sp_helpdb DB
go

use master
go

[ComingKayak]

初学者建议用命令行

最简单的方法是用Sybase Central,按照一下步骤,
先用Sybase服务器端的服务器配置建立一个服务器,注意设置好服务器IP,和端口号(端口号设为5000以后的值);
利用Sybase Central连接到服务器;
利用Wizard按照下列顺序建立;Divice,Database,配置好数据库的管理权限等等!
Everything is OK!

[mantis]

建立设备
print 'test_data'
declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3

disk init name='test_data',physname='D:\DbServer\Sybase\data\test_data.dat', vdevno = @vdevno ,size=76800,vstart=33554432,cntrltype=0
go

exec sp_diskdefault 'test_data',defaulton
go

print 'test_temp'
declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3

disk init name='test_temp',physname='D:\DbServer\Sybase\data\test_temp.dat', vdevno = @vdevno ,size=25600,vstart=50331648,cntrltype=0
go

print 'test_Data_backup'
exec sp_addumpdevice 'disk','test_Data_backup','E:\DbBak\Sybase\test_Data_backup'
go


建立数据库
print 'test'
use master
go
create database test on test_data = 150
alter database test ON test_temp = 50
go

use test
go

exec sp_extendsegment 'logsegment','test', 'test_temp'
go

exec sp_dropsegment 'logsegment', 'test','test_data'
go

exec sp_changedbowner 'sa'
go

[fredwu]

reconfigure?
版本太老了吧

[tramplai]

windows 下根本不要这么麻烦