August 12, 2005 at 1:02 pm
We had to detach and reattach our database on 7/29 - the system has worked fine, however, I just noticed that the dates aren't changing on the .MDF or .LDF files - how can this be possible ? where is the data going ?
August 12, 2005 at 1:06 pm
Do you have multiple db files? Is the db being used and working?
August 12, 2005 at 1:17 pm
We have 1 db and everything appears to be working fine. This is our accounting db so if it was a problem, we would have know long ago
August 12, 2005 at 1:18 pm
I'd say you're fine... Seems you have all systems go.
August 12, 2005 at 1:29 pm
wow..thanks, I was getting pretty nervous
August 12, 2005 at 1:38 pm
Ya, those file are locked, I mean DEAD locked. You can't even copy them file they are attached. Maybe that cause some other side effects as this one.
August 12, 2005 at 2:04 pm
files dates attached to sql server don't change if you are only manupulating data.
the dates change only if:
file is expending.
file is shrinking.
stop or restart sql server.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply