disk init
name='tempdb',
physname='/sybase/data/tempdb',
vdevno=3,
size=20480
go
alter database tempdb
on tempdb=40
go
disk init
name='wkdatadb',
physname='/sybase/data/wkdatadb',
vdevno=4,
size=204800
go
disk init
name='wkindexdb',
physname='/sybase/data/wkindexdb',
vdevno=5,
size=51200
go
disk init
name='wkdblog',
physname='/sybase/data/wkdblog',
vdevno=6,
size=102400
go
disk init
name='hisdatadb',
physname='/sybase/data/hisdatadb',
vdevno=7,
size=1024000
go
disk init
name='hisindexdb',
physname='/sybase/data/hisindexdb',
vdevno=8,
size=153600
go
disk init
name='hisdblog',
physname='/sybase/data/hisdblog',
vdevno=9,
size=204800
go
create database MBFEWKDB
on wkdatadb=400,wkindexdb=100
log on wkdblog=200
go
create database MBFEHISDB
on hisdatadb=2000,hisindexdb=300
log on hisdblog=400
go
use MBFEWKDB
go
sp_addsegment seg_wkdata,MBFEWKDB,wkdatadb
go
sp_addsegment seg_wkindex,MBFEWKDB,wkindexdb
go
use MBFEHISDB
go
sp_addsegment seg_hisdata,MBFEHISDB,hisdatadb
go
sp_addsegment seg_hisindex,MBFEHISDB,hisindexdb
go
use master
go
sp_addlogin 'ccpcuser','key123'
go
sp_addlogin 'mbuser','key456'
go
sp_addlogin 'pbuser','key789'
go
sp_addlogin 'appuser','appuser'
go
use MBFEWKDB
go
sp_addgroup mbfe
go
use MBFEHISDB
go
sp_addgroup mbfe
go
use MBFEWKDB
go
sp_adduser ccpcuser,ccpcuser,mbfe
go
sp_adduser mbuser,mbuser,mbfe
go
sp_adduser pbuser,pbuser,mbfe
go
sp_adduser appuser,appuser
go
use MBFEHISDB
go
sp_adduser ccpcuser,ccpcuser,mbfe
go
sp_adduser mbuser,mbuser,mbfe
go
sp_adduser pbuser,pbuser,mbfe
go
sp_adduser appuser,appuser
go
以上脚本,执行到红色脚本部分报以下信息,不知道各位前辈是否见过,
希望与大家一起讨论,分享!
Server Message: Number 1805, Severity 10
Line 1:
CREATE DATABASE: allocating 204800 pages on disk 'wkdatadb'
Server Message: Number 1805, Severity 10
Line 1:
CREATE DATABASE: allocating 51200 pages on disk 'wkindexdb'
Server Message: Number 1805, Severity 10
Line 1:
CREATE DATABASE: allocating 102400 pages on disk 'wkdblog'
Server Message: Number 695, Severity 21
Line 1:
An attempt was made to read logical page '221440' for object '99' in database '7' from disk. Wrong logical page '72960' was brought into cache 'default data cache'.
Server Message: Number 1813, Severity 16
Line 1:
Cannot open new database 'MBFEWKDB'. CREATE DATABASE is aborted.