목록sp_helpfile (1)
Data Modeling Evangelist Kaien Kim's Blog
[SQLServer] 데이터베이스 용량관리
USE AdventureWorks GO EXEC sp_helpfile -------- 1) EXEC sp_spaceused -------- 2) DBCC sqlperf(logspace) -------- 3) ALTER DATABASE AdventureWorks MODIFY FILE ( NAME = AdventureWorks_Data, SIZE = 500 ) EXEC sp_helpfile -------- 4) ALTER DATABASE AdventureWorks MODIFY FILE ( NAME = AdventureWorks_Data, FILEGROWTH = 100, MAXSIZE = 500 ) GO -------- 5) ALTER DATABASE AdventureWorks MODIFY FILE ( NAM..
카테고리 없음
2010. 3. 16. 11:00