Error while moving logfiles in a clustered sql server 2005?

• AAkula

  SSCertifiable

  Points: 5394

  More actions

  October 11, 2008 at 6:09 pm

  #126964

  Hi All,

  Iam using the following method to Move log files of user database. It is a clutered environment

  USE master;

  GO

  -- Return the logical file name.

  SELECT name, physical_name AS CurrentLocation, state_desc

  FROM sys.master_files

  WHERE database_id = DB_ID(N'AdventureWorks')

  AND type_desc = N'LOG';

  GO

  ALTER DATABASE AdventureWorks SET OFFLINE;

  GO

  -- Physically move the file to a new location.

  -- In the following statement, modify the path specified in FILENAME to

  -- the new location of the file on your server.

  ALTER DATABASE AdventureWorks

  MODIFY FILE ( NAME = AdventureWorks_Log,

  FILENAME = 'H:\NewLoc\AdventureWorks_Log.ldf');

  After executing the last step Iam getting the following error:

  Msg 5184, Level 16, State 2, Line 1

  Cannot use file 'H:\NewLoc\AdventureWorks_Log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

  Msg 942, Level 14, State 4, Line 1

  Database 'AdventureWorks' cannot be opened because it is offline.

  Could you plz tell me what I have to do to Move User and system databases log n data file to different drives In clustered sql server 2005?

  Thanks

• DNA_DBA

  SSCrazy Eights

  Points: 9107

  More actions

  October 12, 2008 at 1:33 am

  #883854

  Is the H: drive a resource in the cluster? It needs to be added to the sql group and it should be a dependency for the sql server resource.

• AAkula

  SSCertifiable

  Points: 5394

  More actions

  October 13, 2008 at 12:58 am

  #883987

  Thanks DNA,

  Its solved.. by adding the drives in sql server resource group as dependies...

• cherukuri1974-891990

  SSC Rookie

  Points: 34

  More actions

  October 13, 2008 at 8:22 am

  #884163

  Hi Kotalas,

  Can you tell some thing how add a drive to sql dependence group in cluster environment

  sureesh