SQL Server Performance Forum – Threads Archive
MOVE LOG FILE to another drive
<br />I need to move the log file of my SQL Server 2000 database to another <br />drive. <br /><br />I detached the db <br /><br />Copied to log fle over to another drive <br /><br />But when I go back to attach the db using EM, I cannot find a place to ask it find the log file in a different place than in the same place where there is the MDF file! <br /><br />Any help would be appreciated <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /> <br /><br />I tried this but it results in an error:<br /><br />EXEC sp_attach_db @dbname = ‘MASProd’, <br /> @filename1 = ‘G:MASProd_Data.MDF’, <br /> @filename2 = ‘H:MASProd_Log.LDF'<br /><br /><b>ERROR:</b><br /><br />Server: Msg 9003, Level 20, State 1, Line 1<br />The LSN (749:1561:1) passed to log scan in database ‘MASProd’ is invalid.<br /><br />Connection Broken<br /><br />Sunny Kanaparthy is a software developer with the University of New Orleans, LA, USA.<br /><br />
I did the same rightnow with EM and no problem.
When you attach using EM, ask for mdf and show path where mdf is, and assume that log is in the same place.
But, you can edit new path were log actually is and work OK. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
please refer tohttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2810
]]>