Hi I am new to SQL Server,
I have questions regarding theses files TRN, LDF, MDF and BAK.
I have a maintenance plan that backups the .TRN and .BAK everynight in a folder e:/mssqlsrv/MSSQL/Bakup.
When I look at the date modified in windows explorer they are exactly like I programmed it in the maintenance plan.
Now when I look in the folder e:/mssqlsrv/MSSQL/Data I see the .LDF and .MDF files and they are way out of date.
How do they get copied there (the ldf and mdf)? With the maintenance plan? What is the difference between the TRN and the LDF?
How does a restore work? I am so confused? Please explain to me?