Post reply

Log problem

  • July 25, 2005 at 4:19 am

    #110155

     

    Hi,

    I have a database with 2 logfile residing on diffrent derives.

    Can anybody explain me how sql server switch over to the logfiles.

    thanx

    killer

  • July 26, 2005 at 8:21 pm

    #577361

    If these 2 have different logical names associated with them, then try

    1. sp_detach_db

    2. Move the Physical files to required folders

    3. sp_attach_db


    paul

  • July 26, 2005 at 8:38 pm

    #577368

    Dear Sir,

    Thanx for ur reply. But i want help that how sql server uses the user defined log file.How sql server comes to know that now it has to use the second logfile.

    from

    killer

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

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