Example 5-1
------------------------------------------------------------------------------------------------
CREATE DATABASE MyDB
	ON
	(NAME = MyDB_root,            
	FILENAME = 'c:\MSSQL\data\mydbroot.mdf',
SIZE = 5MB, MAXSIZE = 10MB,
FILEGROWTH = 100KB),(NAME = MyDB_data1, 
	FILENAME = 'C:\MSSQL\Data\logdata1.ldf',
	SIZE = 10MB,
	MAXSIZE = 15MB,FILEGROWTH = 1MB)


Example 5-2
------------------------------------------------------------------------------------------------
CREATE DATABASE YourDB
	ON
	(NAME = YourDB _root,            
	FILENAME = 'c:\MSSQL\data\YourDB root.mdf',
	SIZE = 5MB,MAXSIZE = 10MB,
	FILEGROWTH = 100KB),(NAME = YourDB_data1,           
	FILENAME='c:\MSSQL\data\YourDB data1.ndf',
	SIZE = 10MB,MAXSIZE = 100MB,
	FILEGROWTH = 1MB)
	LOG ON
	(NAME = YourDBLog_data1,            
	FILENAME = 'C:\MSSQL\Data\yrlogdata1.ldf',
	SIZE = 10MB,MAXSIZE=15MB,FILEGROWTH = 1MB)

 

Example 5-3
------------------------------------------------------------------------------------------------
CREATE DATABASE yourDatabase



Example 5-4
------------------------------------------------------------------------------------------------
DROP DATABASE MyDB

Example 5-5
------------------------------------------------------------------------------------------------
USE master
GO
CREATE DATABASE Test1 ON
(
 NAME = Test1dat1, 
 FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat1.ndf',
 SIZE = 5MB,
 MAXSIZE = 100MB,
 FILEGROWTH = 5MB
)
GO



Example 5-6
------------------------------------------------------------------------------------------------
ALTER DATABASE Test1 
MODIFY NAME =Test2
GO



Example 5-7
------------------------------------------------------------------------------------------------
ALTER DATABASE Test2
ADD FILE 
(
 NAME = Test1dat2,
 FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat2.ndf',
 SIZE = 5MB,
 MAXSIZE = 100MB,
 FILEGROWTH = 5MB
 )


Example 5-8
------------------------------------------------------------------------------------------------
Create database Test3



Example 5-9
------------------------------------------------------------------------------------------------
sp_renamedb Test3 , Test4

Example 5-10
------------------------------------------------------------------------------------------------
DBCC SHRINKDATABASE (mydatabase, 10)
	GO


Example 5-11
------------------------------------------------------------------------------------------------

sp_detach_db 'mydatabase', 'false'


Example 5-12
------------------------------------------------------------------------------------------------
EXEC sp_attach_db 
			@dbname = N'mydatabase', 
		   	@filename1 = N'D:\Program Files\Microsoft 
			SQL Server\MSSQL\Data\ 
			mydatabase_data.mdf', 
			@filename2 = N'D:\Program Files\Microsoft 
			SQL Server\MSSQL\Data\
			mydatabase_log.ldf'
