Tuesday 13 December 2016

create .mdf .ldf and .ndf into different location

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

No comments:

Post a Comment