create .mdf .ldf and .ndf into different location

CREATE DATABASE TestON 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

RECENT POST

SQL Server Query Store (SQL SERVER 2016)

Update Second Row if two rows has same values

Strign repeated in a row

Select all columns but Group by only some selective column :-

create .mdf .ldf and .ndf into different location

Check current executing Query over the server :-

The Role of MDF and LDF in SQL SERVER

SQL Server top 50 interview Question for DBA

Create an user define file group and take backup for it :

Total execution time for an SP