March 13, 2006 at 10:18 am
Log entry: 2006-03-12 10:30:15.84
correspoinding "Message" has a different date:
Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56),...
DBCC CHECKDB for the msdb database, reports NO errors!
Any ideas?
Thanks in advance for any help!
MS WinNT 5.2 (3790)
SQL Server Standard Edition 8.00.2039 (SP4)
Joe Burdette
hanesbrands.com
March 13, 2006 at 10:37 am
Nothing is wrong. You are comparing 'apples and oranges'.
creation date(time): 2000/08/06(01:40:56),...
That is the CREATION DATE(Time) of the database - not the backup.
-SQLBill
March 13, 2006 at 11:16 am
Joe Burdette
hanesbrands.com
March 13, 2006 at 12:59 pm
Pretty sad isn't it? Right click on a file and select properties. You'll see when it was last updated. Cool. Now click on an .mdf file all it shows is when it was created.
-SQLBill
March 13, 2006 at 1:12 pm
regarding the .mdf file... yes, checking the properties shows when the file was created, the "Modified" and "Accessed" times will coincide with the last time the SQL Server was restarted...
Joe Burdette
hanesbrands.com
March 13, 2006 at 3:02 pm
Agree with the grrrr expression. These are different dates.
The file properties for the test database say: THIS database created Monday, May 16, 2005, 2:27:47 PM The backup record in the event log for THIS database says: creation date(time): 2005/06/22(11:42:26), pages dumped: 1
My records of May 16 2005 say: restored THIS database on myserver. It looks like it was restored for the first time when creating the test environment on this server. My records of 6/22/2005 also say that I restored THIS database on this server again to refresh data for the test environment.
So the file properties reflect when the file was created here for the first time and the backup record refers to the date the database was restored for this file
Regards,Yelena Varsha
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply