Tuesday, 13 December 2016

create .mdf .ldf and .ndf into different location

CREATE DATABASE Test ON PRIMARY(NAME = Test_Data, FILENAME = 'C:\SQL\Test_Data1.mdf'),FILEGROUP [OrderHist] (NAME = Test_Hist1, FILENAME = 'D:\SQL\Test_Hist1.ndf'),
(
NAME = Test_Hist2, FILENAME = 'D:\SQL\Test.ndf')LOG ON(NAME = Test_Log, 
FILENAME = 'E:\SQL\Test.ldf')GO

No comments:

Post a Comment