보미네

C:\Program Files\Smart Storage Administrator\ssacli\bin>ssacli ctrl slot=0 ld all show status
   logicaldrive 1 (10.17 TB, RAID 5): OK

C:\Program Files\Smart Storage Administrator\ssacli\bin>ssacli ctrl slot=0 pd all show status
   physicaldrive 1I:1:1 (port 1I:box 1:bay 1, 1.9 TB): OK
   physicaldrive 1I:1:2 (port 1I:box 1:bay 2, 1.9 TB): OK
   physicaldrive 1I:1:3 (port 1I:box 1:bay 3, 1.9 TB): OK
   physicaldrive 1I:1:4 (port 1I:box 1:bay 4, 1.9 TB): OK
   physicaldrive 1I:1:5 (port 1I:box 1:bay 5, 1.9 TB): OK

declare @dbName nvarchar(1000) ='storageTest'
declare @incSizeGigaBytes int = 10

-- internal variable 
declare @currentGigaBytes bigint 
, @tobeGigaBytes bigint 
, @message nvarchar(4000) = N''
, @mdfFileName nvarchar(1000) = N''
, @fileName nvarchar(1000) = N''
, @sql nvarchar(max)


select @currentGigaBytes = (size * 8) / power(2,20) , @fileName = name 
from master.dbo.sysaltfiles
where dbid = db_id(@dbName)
	and fileid = 1 

select @tobeGigaBytes = @currentGigaBytes + @incSizeGigaBytes 

select @message = N'currentGigaBytes : ' + cast (@currentGigaBytes as nvarchar(4000)) + ', tobeGigaBytes : ' +  cast (@tobeGigaBytes as nvarchar(4000)) 
select @message 

-- log
RAISERROR(@message, 1,1 ) WITH LOG, NOWAIT
set @sql = 'ALTER DATABASE '+@dbName+' MODIFY FILE ( NAME = N'''+@fileName+''', SIZE = '+cast(@tobeGigaBytes as nvarchar(100))+'GB, FILEGROWTH = 512MB)'
print @sql 

-- cmd 
exec (@sql)