Mark Forums Read

Location for master model ... db

Go Back

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Reply

Page 1 of 2

1

#1

Old

Pasquale

Posts: n/a

Location for master model ... db - 07-23-2008 , 03:55 AM

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 With Quote

#2

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#3

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#4

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#5

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#6

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#7

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#8

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#9

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

#10

Old

Denny Cherry

Posts: n/a

Re: Location for master model ... db - 07-23-2008 , 11:42 AM

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

On Wed, 23 Jul 2008 01:55:01 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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 With Quote

Reply

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.