Data Backup and Recovery

SMSQL with SQL System Root

andre_columbia
2,653 Views

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
2,653 Views

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
2,653 Views

Hi Sourav,

I will test and reply to you with the conclusion.

tks

André Dobrões

Public