SQL SERVER DATABASE WITH SAN STORAGE

Question

I am preparing for SQL server cluster with servers 2016, linked with Dynamics AX 2012,
I have two options:
1- Store Database on external SAN storage.
2- Store database on local shared location on any physical server.

I need to know how to store SQL server database on external SAN storage?????

Answer 1

hi,

Check this post: SAN Storage Best Practices for SQL Server, by Brent Ozar

Answer 2

Hi @Ahmed Maher Abdelsalam ,

According to MS document, you may use SAN storage to store your databases' files. This use requires the -T1807 startup trace flag to work in Microsoft SQL Server 2008 and earlier versions. This use is enabled by default in Microsoft SQL Server 2008 R2 and later versions. Give full permissions to your account on shared folder.

DBCC TraceOn(1807);  
GO   -----This step only need for Microsoft SQL Server 2008 and earlier versions  
  
Use master;  
GO  
  
CREATE DATABASE [test]   
    ON  PRIMARY (  
        NAME = N'test',   
        FILENAME = N'\\PC-Name-Where-Share-Is\TempDB\test.mdf' ,   
        SIZE = 2048KB ,   
        FILEGROWTH = 1024KB  
        )  
    LOG ON (   
        NAME = N'test_log',   
        FILENAME = N'\\PC-Name-Where-Share-Is\TempDB\test_log.ldf' ,   
        SIZE = 1024KB ,   
        FILEGROWTH = 10%  
    )  
GO  

Refer to this similar thread.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".