Big PRB on Cluster

• tsc1

  SSC-Addicted

  Points: 493

  More actions

  May 26, 2004 at 10:15 am

  #84582

  Hi,

  We install SQL SERVER 2000 sp3a on a win2003 cluster

  It's an active-active cluster with 2 instance.

  When I try to create a DB I got the error

  "Only formatted files on which the cluster resource of the server has a dependency can be used.

  Server: Msg 1802, Level 16, State 1, Line 1

  CREATE DATABASE failed. Some file names listed could not be created. Check previous errors."

  according to http://support.microsoft.com/?id=811889

  I have to add te ressource disk to sql server ressource. I do it.

  I can create a db, and I modify the physical datafiles of TEMPDB(put it on a RAID 1 ressource).

  When SQL SERVER restart, SQL SERVER failed !!!

  I cannot START the SQL SERCER instance !!

   

  Can you help me ??

  Tom

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 26, 2004 at 10:22 am

  #507886

  How did you modify the location of tempdb? And are there any messages in the error log or system event log to indicate the problem?

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• tsc1

  SSC-Addicted

  Points: 493

  More actions

  May 26, 2004 at 11:06 am

  #507893

  Got it !!!!!!!!

  I check my SQL on my stage DB server .

  BUT GIVE THE SAME Physical NAME !!!!!

  I modify It by alter database modify file...., Standard manipulation

   

  But error log and event log don"t really explain me . I read

  'c:\toto.ldm' is not a primary database file' !! Hard to understand !!

  ANd no comment of SQL Error when I start with -f options ...

   

  First time I make such a mistake !!!!

  Thank you ...

  tom