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'