I have sql server 2005 database, which is hosted on my dedicated server.The issue is whenever i look into the default location of the .mdf and .ldf files, it shows me date of back 8 months as last modified date, although the data objects are fully updated
as we make new objects everyday.
I thought it could not be a serious problem and downloaded the files to local server, then after i attached a new database by using those files and changing their names. I was wondered that it showed me the old data almost of 8 months back.
I don't know what is the problem, why these files on the server are not updating, if anyone has the solution please alert me as possible.
View Complete Post