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
Thanks. I used it today.
ReplyDelete