Skip to main content
Planview Customer Success Center

Log file for CPTransport database is missing

Symptoms
Installation instructions for Transport Tool requires the attachment of CPTransport.mdf, attempting to attach the file SQL, an error comes up stating the .ldf file is missing.

Error/Warning Messages
Directory lookup for the file (file path for CPTransport_log.ldf) failed with the operating system error 3(the system cannot find the path specified).

Reason
Log file is not present


Resolution
If the LDF file is not present then we have to build the LDF file from the MDF file by doing the below (using the attach_rebuild_log command).

CREATE DATABASE CPTransport ON
(FILENAME = N'C:\Database\CPTransport.MDF')
FOR ATTACH_REBUILD_LOG
GO