SQL Server Performance

move a log file

Discussion in 'SQL Server Log Shipping' started by Arp, Dec 14, 2004.

  1. Arp New Member

    Hello
    I want to move a log file from SQL server 2000 standard Ed to another drive. The SQL server DB is in simple recovery model. I don#%92t use SP_DETACH_DB and SP_ATTACH_DB concept. I wonder if there is some another solution for it.
    Thanks
    Arp
    Arp, Dec 14, 2004
    #2

  2. FrankKalis Moderator

    If this is in simple recovery mode, what do you want to do with the log file anyway?

    -----------------------
    --Frank
    http://www.insidesql.de
    -----------------------
    FrankKalis, Dec 14, 2004
    #2

  3. Arp New Member

    Then I‘m going to change the SQL server DB in full recovery model.
    quote:Originally posted by FrankKalis

    If this is in simple recovery mode, what do you want to do with the log file anyway?

    -----------------------
    --Frank
    http://www.insidesql.de
    -----------------------

    Arp, Dec 14, 2004
    #2

  4. thomas New Member

    What do you mean you "don't" use detach and attach? This sort of thing is PRECISELY what it is there for? Are you ideologically opposed to it?

    Tom Pullen
    DBA, Oxfam GB
    thomas, Dec 14, 2004
    #2

  5. satya Moderator

    True and there is no other process or option to move the Log file alongwith data file, any process uses the same method of detach and attach.



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 14, 2004
    #2

Share This Page