• First you are going to have to detach the db using <b>sp_detach_db</b>. Then move the log to the new location and use <b>sp_attach_db</b>.

    The easiest way to do this is to open up SQL Query Analyzer and run these procedures. Look up on technet.com and/or MSDN for a description on how to use these procs.

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com