Database Creation Date - Screwy Results
-
I looked at the DB properties of a DB, and it says it was created last week, but it's been on the server for a year or so. I looked up a few more, and they all had dates within the last week, one even for 1 am this morning. What's going on ??
-
Do you remember deleting the database and then restoring it again in the server? Because when you restore it (given that you delete it first) will be created again thus the date created will be changed to the date when you restore your database
"-=Still Learning=-"
Lester Policarpio
-
No. These databases have creation dates within the last week or so, and I haven't done anything with them in months.
-
interesting; other than a restore of the data, everything i tried so far left the CRDATE in master.dbo.sysdatabases intact:
stopping/starting server. also tried rebooting the server.
backup full database, then backup transaction log.
dbcc reindex
shrink of the database.
i ran out of guesses as to what might be chanigng the date on you.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Got it !! Detach & re-attach. Some DBs were moved to new storage recently ... Too bad that it wipes out the real creation date 🙁
Thanks for helping
-
Sorry homebrew01, but I have to do this. "I didn't do anything... But now it doesn't work"
I just hear that so often. -
Yeah yeah ... I know .... smartass !!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply