Data Backup and Recovery Discussions

SMSQL and MountPoints

cheche030

Hi,

           I must migrate a cluster with 6 SQL Server instances and a lot of database to SMSQL. I don't understand very well SMSQL manual about MountPoints. Help, I need to know if I can put all objetcs on a MountPoint:

  • Databases LUN
  • Logs LUN
  • SnapInfo LUN
  • System Databases LUN

Thank You very mutch.

1 ACCEPTED SOLUTION

stephan_troxler

You need different LUNs (and therefore mountpoints) for Snapinfo, UserDBs and UserLogs and since it's best practice also for the TempDb and the TempLog. A possible structure would be for example:

X: --> driveletter as "root" LUN (per instance as install directory of the SQL instance, also containing the SYSDbs)

X:\<instancename>_UserDB --> mountpoint

X:\<instancename>_UserLOG --> mountpoint

X:\<instancename>_TempDB --> mountpoint

X:\<instancename>_TempLOG --> mountpoint

X:\<instancename>_Snapinfo --> mountpoint

For the next instance you can create the same structure with a new drive letter as "root" LUN.

View solution in original post

4 REPLIES 4

stephan_troxler

You need different LUNs (and therefore mountpoints) for Snapinfo, UserDBs and UserLogs and since it's best practice also for the TempDb and the TempLog. A possible structure would be for example:

X: --> driveletter as "root" LUN (per instance as install directory of the SQL instance, also containing the SYSDbs)

X:\<instancename>_UserDB --> mountpoint

X:\<instancename>_UserLOG --> mountpoint

X:\<instancename>_TempDB --> mountpoint

X:\<instancename>_TempLOG --> mountpoint

X:\<instancename>_Snapinfo --> mountpoint

For the next instance you can create the same structure with a new drive letter as "root" LUN.

View solution in original post

cheche030

Thanks for de answer.

But, the manual sais: You cannot store database files on a mount point root .

Then, SYSDbs can be stored on mount point root?

stephan_troxler

Yes, it's possible to store the SYSDBs in the root because the SYSDBs are not backed up via snapshot but dumped with SQL Server functionality.

Of course you could also add an additional mountpoint per instance as system root, just for the installation.

cheche030

I understand. Thank you very mutch.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public