Very Strange. I get the error but the Log File has moved.
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'Staging');
name CurrentLocation state_desc
CypressStaging D:\MSSQL\Data\Staging.mdf ONLINE
CypressStaging_logL:\MSSQL\Log\Staging.ldf ONLINE
It crashed and burned when I tried to restore to the new log file location.
It is a big database.
Weird.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/