jamminjaymeyer
Programmer
Hello,
I get a message:
Server: Msg 823, Level 24, State 3, Line 1
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x0000014b576000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CRData_Data.MDF'.
Whenever I try to do anything with the transaction log. I have it set on Simple recovery right now and want to switch it to full but I get that error. The log finle is on the server but it is just named "Program Files" no extension or nothing, and it is about 4 gig big. Any ideas how I can truncate this log and get back to full recovery model?
I get a message:
Server: Msg 823, Level 24, State 3, Line 1
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x0000014b576000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CRData_Data.MDF'.
Whenever I try to do anything with the transaction log. I have it set on Simple recovery right now and want to switch it to full but I get that error. The log finle is on the server but it is just named "Program Files" no extension or nothing, and it is about 4 gig big. Any ideas how I can truncate this log and get back to full recovery model?