How to find the How old is the Database Backup

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to find the How old is the Database Backup

Author

Topic

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 2007-08-31 : 13:27:19

HI,
We get our Database restored regularly in our test enviornment.
I am trying to find out the Database Backup Time stamp through system tables and I am not able find .
If you guys know ,please let me know.
Thanks,
Raju

Thanks!
Raju
http://rajusqlblog.blogspot.com/

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-08-31 : 13:56:37

quote:
Originally posted by vgr.raju

HI,
We get our Database restored regularly in our test enviornment.
I am trying to find out the Database Backup Time stamp through system tables and I am not able find .
If you guys know ,please let me know.
Thanks,
Raju

Thanks!
Raju
http://rajusqlblog.blogspot.com/

USE MSDB
SELECT * FROM Backupset

There is a backup_start_date and backup_finish_date in there.

/*-----------------------
Words are but constrained thoughts.
------------------------*/

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 2007-08-31 : 14:17:37

Thanks for the Reply.
I think I did not make my question clear.
Different Team restores the Databases in our Test Server from Backups they get from Production.

I am trying to figure out the timestamp of the Backup from Production.

Is there any system tables which keeps track of of the Backup files timestamp values while it restores the backups?

Thanks,
Raju

Thanks!
Raju
http://rajusqlblog.blogspot.com/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 15:07:49

Sql keeps backup history but not restore ones.

Haywood
Posting Yak Master

221 Posts

Posted - 2007-08-31 : 16:47:51

RESTORE HEADERONLY will give you the details you want.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-09-01 : 01:06:30

Hi,

Check the Link once it may help u to get the BackupHistory details..
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1662

Peter

Kristen
Test

22859 Posts

Posted - 2007-09-01 : 05:06:29

"Sql keeps backup history but not restore ones."

Not sure I agree with that (c.f. msdb.dbo.restorehistory) - unless I have misunderstood?

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#268882

Kristen

Kristen
Test

22859 Posts

Posted - 2007-09-01 : 05:08:16

"I am trying to figure out the timestamp of the Backup from Production"

I wonder if MSDB holds that, once a Backup file (i.e. copied from "somewhere else") has been restored?

See the link to Restore History I posted above.

Otherwise I reckon you are going to have to update some Date/Time Stamp value in the Source database periodically, so that it can be "retrieved" on the Restored site

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources