Create a database

Create a database

CREATE Database testdb1on (name=Testdb1,filename='D:\testdb1.mdf', size=Ten, MaxSize= -, FileGrowth=1) Log on (name=Testdb_log,filename='D:\testdb_log.ldf', size=1, MaxSize=unlimited,filegrowth=Ten%) Go

View Code

CREATE Database testdb1on (name=Testdb1,filename='D:\testdb1.mdf', size=Ten, MaxSize= -, FileGrowth=1) Log on (name=Testdb1_log,filename='D:\testdb1_log.ldf', size=1, MaxSize=unlimited,filegrowth=Ten%), (name=Testdb2_log,filename='D:\testdb2_log.ldf', size=1, MaxSize=unlimited,filegrowth=Ten%) Go

View Code

View database Information

Execute sp_helpdb TESTDB1

or sp_helpdb

sp_helpdb testdb1alter Database testdb1add file (name=Testdb1ndf1,filename='D:\TESTDB1NDF1.NDF', size=5mb,maxsize=10mb,filegrowth=6MB) to filegroup mygroupalter database testdb1add log file (name=Testdb3_log,filename='D:\testdb3.ldf', size=5mb,maxsize=10mb,filegrowth=Ten%ALTER DATABASE testdb1modify file (name=testdb1,size=21mb) Goalter database testdb1modify file (name=testdb_log,size=21MB) ALTER DATABASE TESTDB1ADD filegroup mygroupgosp_helpfilegroupgosp_helpdb testdb1alter Database Testdb1remove File Testdb3_log

View Code

Filegroup Usage http://blog.csdn.net/kevinsqlserver/article/details/8573312

Set the database to read only

Properties → options → state → database read-only true

Create a database