• 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/