/*
USE Diablo ;
GO
-- LITESPEED
SELECT 'MOVE N''' + name + ''' TO N''' + CASE WHEN f.status & 0x40 = 0x40 THEN 'C:\Microsoft SQL Server\Log\'
ELSE 'E:\Microsoft SQL Server\Data\'
END + DB_NAME() + 'V2_' + name
+ CASE WHEN fg.groupname = 'PRIMARY' THEN '.mdf'
WHEN f.status & 0x40 = 0x40 THEN '.ldf'
ELSE '.ndf'
END + ''','
FROM sys.sysfiles f
LEFT OUTER JOIN sys.sysfilegroups fg ON f.groupid = fg.groupid
ORDER BY f.name
*/
GO
RESTORE DATABASE [DiabloV2] FROM DISK = N'C:\Temp\DiabloV2.bak'
WITH FILE = 1,
MOVE N'Audit_Tax_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Audit_Tax_1.ndf',
MOVE N'Audit_Trans_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Audit_Trans_1.ndf',
MOVE N'CDC_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_CDC_1.ndf',
MOVE N'Common_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Common_1.ndf',
MOVE N'Diablo' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Diablo.mdf',
MOVE N'Diablo_Default_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Diablo_Default_1.ndf',
MOVE N'Diablo_log' TO N'C:\Microsoft SQL Server\Log\DiabloV2_Diablo_log.ldf',
MOVE N'Propagation_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Propagation_1.ndf',
MOVE N'Propagation_2' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Propagation_2.ndf',
MOVE N'Tax_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Tax_1.ndf',
MOVE N'Tax_2' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Tax_2.ndf',
MOVE N'Trans_1' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Trans_1.ndf',
MOVE N'Trans_2' TO N'E:\Microsoft SQL Server\Data\DiabloV2_Trans_2.ndf',
KEEP_CDC,
NOUNLOAD,
REPLACE,
STATS = 10
GO