moving log files away from same disk as data files on a sql cluster

• lara31

  SSCommitted

  Points: 1802

  More actions

  April 25, 2005 at 12:40 pm

  #88251

  i did the following,

  chnaged db to single user mode,

  detached the db

  copied the log file to the new location,(f:\logs)

  then i attempted to attach, this locations:

  E:\Program Files\Microsoft SQL Server\MSSQL$SQLCLUS\Data\XXX.MDF

  F:\logs\XXX.LDF

  I got an error that the database file already existed.

  so i created a new folder, (e:\data) and copied the data files to it.

   then i did

   

  E:\Data\XXX.MDF                                                                                                                                                                          

  F:\LOg\Data\XXX.LDF

  it worked but when i went into the EM to view the database, i noticed that the database was in read only mode, so i tried to change it from read only and got error messages. and i doing something wrong?

  [font="Comic Sans MS"][/font]It is what it is.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 25, 2005 at 2:48 pm

  #554712

  Did you reattach through the EM? Make sure to refresh the database after each action.