October 24, 2005 at 8:52 am
I had logs backed up on 2 databases and the server logs shows
Log backed up: Database: DB1, creation date(time): 2004/06/23(14:03:43), first LSN: 1236898:85:1, last LSN: 1237232:14009:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB120051024_083004.TRN'}).
Log backed up: Database: DB2, creation date(time): 2004/09/17(16:28:31), first LSN: 127291:83:1, last LSN: 127515:9301:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB220051024_083004.TRN'}).
Where does it get the creation date ?
October 24, 2005 at 8:59 am
I'm pretty sure it's from the server, since my backup date/times match my server date/times.
-SQLBill
October 24, 2005 at 9:01 am
These are backup taken today on the production server and the time on the server is today. They are consecutive backups but the dates are different.
October 24, 2005 at 1:26 pm
Just looked over my backup information and those dates are the dates the database was created.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply