Location for master model ... db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasquale - 23 Jul 2008 09:55 GMT

I have a two node cluter. Each node has a local drive (named C) and two
storage units in a SAN, one for the data and the other one for the log.
Is correct to mantain for example the master db in the storage unit reserved
for the data or do I have to move it in local drive (C)?
Where the right location to do to write the SQL Server log?
Thansk

Reply to this Message

Denny Cherry - 23 Jul 2008 17:42 GMT

The system databases and the log files must all be on the shared
storage. SQL Server won't start if they are located on local storage.

Denny

>I have a two node cluter. Each node has a local drive (named C) and two
>storage units in a SAN, one for the data and the other one for the log.
>Is correct to mantain for example the master db in the storage unit reserved
>for the data or do I have to move it in local drive (C)?
>Where the right location to do to write the SQL Server log?
>Thansk

Reply to this Message