[dba-SQLServer] Moving the log file

Susan Harkins ssharkins at setel.com
Mon Oct 2 09:09:14 CDT 2006


JC, I have an article somewhere on this -- I wrote it with Mike G. If you
don't get this figured out, let me know privately and I'll see if I can find
an electronic copy of it. 

Susan H. 

If you are attaching the DB it's like this
>From Query Analyzer

RESTORE DATABASE devREDe FROM DISK = 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\DB.bak'
WITH MOVE 'myDB_log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\DATA\DB_log.ldf'





More information about the dba-SQLServer mailing list