Definitions More Info.
Definition ID	468
Title	SQL
Category	NOTES
Definition	DATABASE MODIFY FILE AND FILEGROUPS
Definition Description	-- Veritabaniadi degistiriliyor alter database egitim modify name = hede -- veritabani default dil ayarlari degistirilebiliyor alter database egitim collate turkish_bin -- Veritabani file ekleme (direkt primary filegroup ekler) alter database egitim add file ( name='prestigeist2', filename='D:\SQLDATA\Data\prestigeist2.ndf', size=6 mb, maxsize=100 mb, filegrowth=20% ) -- file adini,size degistirme. Ancak size kesinlikle küçültülemez!!! alter database egitim modify file ( name=prestige2, newname=prestige3, size=40, maxsize=60, filegrowth=20 ) -- Yeni filegroup olusturulur alter database egitim add filegroup GRUPCUCU -- Burada filegroup yazma ve okuma statusu degerlendiriliyor. alter database egitim modify filegroup tanya readonly/readwrite/default -- burada file gruba file eklenir alter database egitim add file (name='cunito', filename='D:\SQLDATA\Data\cunito_data.ndf', size=8 mb, maxsize=60 mb, filegrowth=20 % ) to filegroup GRUPCUCU --filegroup remove edilioyr. alter database egitim remove filegroup hede --log file ekleme ALTER DATABASE [egitim] ADD LOG FILE ( NAME = N'hedelog', FILENAME = N'D:\SQLDATA\Data\hedelog.ldf' , SIZE = 1024KB , FILEGROWTH = 10%) GO
RecordBy	cunay
Record Date	30-03-2014 22:16:36
Düzenle
Kopyala
Sil