Edward Shaw
Ten Centuries
Points: 1020
More actions
April 12, 2007 at 11:53 am
#116908
I would just like to confirm that the MDF and LDF files in my databases should be updated with the last date the server was rebooted. And if someone could explain to me why this happens I would appreciate it. Thanks.
Ray M
SSC-Insane
Points: 21093
April 12, 2007 at 1:21 pm
#700205
I believe yes.
When you shutdown your server, all services are stopped. at which point sql server "Closes" the mdf and ldf files.
apon reboot, sql server basically "Opens" the files again, and keeps them open until the next service stop, or reboot.
April 12, 2007 at 1:23 pm
#700207
Thank you, that makes sense.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply