Data Backup and Recovery Discussions

SMSQL with SQL System Root

andre_columbia

Hi Guys,

I have a customer with this configuration: Drive D:\, Drive L:\ and Drive R:\. The drive D:\ are the SQL System Root and Users Database, drive L:\ are the logs of all Databases and drive R:\ are to SnapInfo.

If i migrate the system database (model, master, temp) to another drive using the SMSQL, is it possible to leave the bases of users in Drive 😧 \?

tks

2 REPLIES 2

sourav

Hi,

Yes that is absolutely possible and also the best practice. Ideally, SQL Server system and user databases should never co-exist on the same LUN.

Regards,

Sourav.

andre_columbia

Hi Sourav,

I will test and reply to you with the conclusion.

tks

André Dobrões

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