Post reply

Moving transaction log file only

  • July 3, 2006 at 7:31 am

    #191133

    sql server 2000 enterprise edition

     

    Moved transaction log  and datafile files too many times from server to server without issues with the use of sp_attach sp_detach

    Tried doing it on the same server and ran into so many issues.

    Has anyone done this succesfully and what are the gotchas

    Thanks

     

  • July 4, 2006 at 1:11 am

    #647317

    I have done this many times on same server without an issue.  More info on what errors you are encountering may help .

  • July 5, 2006 at 5:17 am

    #647469

    Thanks for your reply.

    again sql server 2000 sp4 32bit

    windows enterprise edition 64bit

     

    This is the long story bare with me please

    An EMC  was attached after the original install and the transaction logs were intended to  be moved to the EMC.

    Steps taken

    1)open up enterprise manager and detach database .

    2)Copy over trans log to emc and try to reattach pointing trans log to new location and database is read only or cannot be recreated.

     summarily attach and attach on non emc drive works  fine,Back up and restore with one file on emc and the other on regular drive works but  attach and detach with one file on emc and the other on regular drive  consistently fails to recreate database or comes up as read only

    Not sure what I am missing but any input is appreciated

     

  • July 5, 2006 at 7:24 am

    #647496

    Are you getting any error messages?

  • July 5, 2006 at 8:53 am

    #647519

    Database comes up in read only mode.

    Or cannot create database error.

    Or failed to recognize  or Server: Msg 5105, Level 16, State 4, Line 1.

    There is no defaultdata and defaultlog values in the registry as suggested by a MS article

    Any ideas ?

  • July 5, 2006 at 7:07 pm

    #647661

    Not quite sure what you mean when you say one file on emc and one file on regular disk works but then you say one file on regular disk and one file on emc fails? Do you mean whenever you put the tran log file on the emc it fails?  A guess would be that the emc disk is not available to the server running sql server, i.e maybe the disk is not allowing write operations from sql server..  only a guess though.

    Derek

  • July 6, 2006 at 5:02 am

    #647705

    Let me clarify ,sorry for the ambiquity.

    Once the attach involves a file move to  the EMC it fails.But it works anyway on the local C and D drives it works.

     

  • July 6, 2006 at 6:13 am

    #647723

    Have you verified the filesystem permissions?  Does the account running the SQL service have r/w access to the database files after they are moved to the SAN?

     

  • July 6, 2006 at 7:27 am

    #647746

    i'm not sure what the format for EMCs is, but on other virtual drives it is required to use the UNC address, eg:

    //host/drive

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply