Monday 18 April 2011

ASE : extend dbccdb

After a user database was expanded, the space requirement for dbccdb will be different. More space is required. To expand dbccdb, I will follow the steps as below.

use master
go
disk init (or resize an existing device)
go
alter database dbccdb on newdevice = xxx
go
use dbccdb
go
sp_extendsegment scanseg, dbccdb, newdevice
go
sp_extendsegment textseg, dbccdb, newdevice
go

1 comment: