dbTalk Databases Forums  

Transaction Logs

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


Discuss Transaction Logs in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lord Melch
 
Posts: n/a

Default Transaction Logs - 05-08-2004 , 11:16 AM






I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K only
asks where you would like to put the SQL data ?

Any tips appreciated.

Cheers
LM

--
Cheers
LM


Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: Transaction Logs - 05-08-2004 , 05:08 PM






Same as you would without SQL. Look in the Books Online for the exact steps.

Cheers,

Rod
"Lord Melch" <lordmelch (AT) nospam (DOT) pls.yahoo.com> wrote

Quote:
I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K
only
asks where you would like to put the SQL data ?

Any tips appreciated.

Cheers
LM

--
Cheers
LM




Reply With Quote
  #3  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: Transaction Logs - 05-10-2004 , 04:09 PM



You may not be able to. Any disk that you want SQL Server to use has to be
in the same resource group as SQL Server and the SQL Server resource must
depend on the disk. If you are trying to put the transaction logs on the
same physiclal drive as the quorom you will not be able to if it is in a
different resource group than the SQL server resource.

Rand
This posting is provided "as is" with no warranties and confers no rights.


Reply With Quote
Reply




Thread Tools
Display Modes

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.