USE [master]
GO
CREATE DATABASE [fred] ON  PRIMARY 
( NAME = N'Fred_Primary', FILENAME = N'C:\Data\DB\Data_1\fred.mdf' , SIZE = 4096KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1000%), 
 FILEGROUP [Fred_FG1]  DEFAULT 
( NAME = N'Fred_Data', FILENAME = N'C:\Data\DB\Data_1\fred_1.ndf' , SIZE = 1024KB , MAXSIZE = 82329600KB , FILEGROWTH = 1048576KB )
 LOG ON 
( NAME = N'Fred_Log', FILENAME = N'C:\Data\DB\Data_1\fred_1.ldf' , SIZE = 1024KB , MAXSIZE = 102400000KB , FILEGROWTH = 1048576KB ), 
( NAME = N'Fred_Log2', FILENAME = N'C:\Data\DB\LDF_1\fred_2.ldf' , SIZE = 105GB, MAXSIZE = 449GB , FILEGROWTH = 1048576KB )
GO
BACKUP DATABASE [fred] TO  DISK = N'C:\Data\backup2\fred.bak' WITH FORMAT, INIT,  NAME = N'fred-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
ALTER DATABASE [fred] 
REMOVE FILE Fred_Log2
GO
BACKUP LOG [fred] TO  DISK = N'Nul' 
GO
ALTER DATABASE [fred] ADD log file
( NAME = N'Fred_Log2', FILENAME = N'C:\Data\DB\LDF_1\fred_8.ldf' , SIZE = 1024KB , MAXSIZE = 665960960KB , FILEGROWTH = 1048576KB )
GO
USE [fred] 
GO
ALTER DATABASE [fred] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
USE [Master]
GO

RESTORE DATABASE [fred] FROM  DISK = N'C:\Data\backup2\fred.bak' WITH  FILE = 1, NOUNLOAD,  REPLACE,  STATS = 10
GO
/*
Msg 3257, Level 16, State 1, Line 1
There is insufficient free space on disk volume 'C:\' to create the database. The database requires 423457128448 additional free bytes, while only 113891102720 bytes are available.
Msg 3119, Level 16, State 4, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
*/
USE [Master]
GO
DROP DATABASE [Fred]
GO