I missed the:
FOR ATTACH_REBUILD_LOG;
I tried it and still got the same error.
I not sure how I should go about renaming the log in T-SQL Syntax.
Thanks.
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/