CREATE DATABASE [Optimization] ON PRIMARY (NAME = N'Optimization_Data', FILENAME = N'D:\SQL Data Files\MSSQL\Data\Optimization_Data.MDF') ,

FILEGROUP [DataPass_Data]
(NAME = N'DataPass_Data', FILENAME = N'N:\SCWW08\Optimization\DataPass_Data.NDF'),
FILEGROUP [Transmission_Index]
(NAME = N'Trans_Index', FILENAME = N'M:\SCWW08\Optimization\Trans_Index_Data.NDF'),
(NAME = N'RealtimeDataPass', FILENAME = N'D:\SQL Data Files\MSSQL\Data\RealtimeDataPass.NDF' ),
FILEGROUP [ICS_Members]
(NAME = N'ICS_Members_Live_Data', FILENAME = N'D:\SQL Data Files\MSSQL\Data\ICS_Members_Live_Data.NDF'),
FILEGROUP [Current]
(NAME = N'RollupCurrent', FILENAME = N'M:\SCWW08\Optimization\RollupCurrent_Data.NDF' ),
FILEGROUP [IDX_Clicks_Clickstreams]
(NAME = N'Clicks_Clickstreams_IDX', FILENAME = N'O:\fromQ2\Optimization\Clicks_Clickstreams_IDX_Data.NDF'),
FILEGROUP [IDX_Clicks_Members]
(NAME = N'Clicks_Members_IDX', FILENAME = N'R:\Optimization\Clicks_Members_IDX_Data.NDF' ),
FILEGROUP [Data_Clicks_Members]
(NAME = N'Clicks_Members', FILENAME = N'O:\fromQ2\Optimization\Clicks_Members_Data.NDF') ,
FILEGROUP [IDX_Clicks_Members_Ex]
(NAME = N'Clicks_Members_Ex_IDX', FILENAME = N'P:\Optimization\Clicks_Members_Ex_IDX_Data.NDF'),
FILEGROUP [Data_Clicks_Members_Ex]
(NAME = N'Clicks_Members_Ex', FILENAME = N'R:\Optimization\Clicks_Members_Ex_Data.NDF' ),
FILEGROUP [IDX_DataPass]
(NAME = N'DataPass_IDX', FILENAME = N'R:\Optimization\DataPass_IDX_Data.NDF' ),
FILEGROUP [IDX_DemUpdate_Clickstreams]
(NAME = N'IDX_DemUpdate_Clickstreams_IDX', FILENAME = N'O:\fromQ2\Optimization\IDX_DemUpdate_Clickstreams_IDX_Data.NDF'),
FILEGROUP [Data_DemUpdate_Clickstreams]
(NAME = N'DemUpdate_Clickstreams', FILENAME = N'P:\Optimization\DemUpdate_Clickstreams_Data.NDF' ) ,
FILEGROUP [IDX_ICS_Clickstreams]
(NAME = N'ICS_Clickstreams_IDX', FILENAME = N'R:\Optimization\ICS_Clickstreams_Data.NDF' ),
FILEGROUP [Data_ICS_Clickstreams]
(NAME = N'ICS_Clickstreams', FILENAME = N'O:\fromQ2\Optimization\ICS_Clickstreams_Data.NDF'),
FILEGROUP [IDX_ICS_Leading]
(NAME = N'ICS_Leading_IDX', FILENAME = N'P:\Optimization\ICS_Leading_IDX_Data.NDF'),
FILEGROUP [Data_ICS_Leading]
(NAME = N'ICS_Leading', FILENAME = N'R:\Optimization\ICS_Leading_Data.NDF'),
FILEGROUP [IDX_ICS_Members]
(NAME = N'ICS_Members_IDX', FILENAME = N'R:\Optimization\ICS_Members_IDX_Data.NDF'),
FILEGROUP [Data_ICS_Members]
(NAME = N'ICS_Members', FILENAME = N'P:\Optimization\ICS_Members_Data.NDF'),
FILEGROUP [IDX_ICS_Rollup]
(NAME = N'ICS_Rollup_IDX', FILENAME = N'R:\Optimization\ICS_Rollup_IDX_Data.NDF'),
FILEGROUP [Data_ICS_Rollup]
(NAME = N'ICS_Rollup', FILENAME = N'O:\fromQ2\Optimization\ICS_Rollup_Data.NDF' ) ,
FILEGROUP [Data_Clicks_Clickstreams]
(NAME = N'Clicks_Clickstreams_Archive', FILENAME = N'P:\Optimization\Clicks_Clickstreams_Archive_Data.NDF')
--LOG ON (NAME = N'Optimization_Log', FILENAME = N'M:\SCWW08\Optimization\Optimization_Log.LDF' )
FOR ATTACH
==============
Server: Msg 3456, Level 21, State 1, Line 1
Could not redo log record (1258226:109843:3), for transaction ID (0:-749698095), on page (4:303945), database 'Optimization' (7). Page: LSN = (1204777:7897:4), type = 3. Log: OpCode = 2, context 5, PrevPageLSN: (1258131:106248:2).

Connection Broken