SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to find the How old is the Database Backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 08/31/2007 :  13:27:19  Show Profile  Visit vgr.raju's Homepage  Reply with Quote
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

USA
702 Posts

Posted - 08/31/2007 :  13:56:37  Show Profile  Reply with Quote
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.
------------------------*/
Go to Top of Page

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 08/31/2007 :  14:17:37  Show Profile  Visit vgr.raju's Homepage  Reply with Quote
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/
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/31/2007 :  15:07:49  Show Profile  Reply with Quote
Sql keeps backup history but not restore ones.
Go to Top of Page

Haywood
Posting Yak Master

USA
221 Posts

Posted - 08/31/2007 :  16:47:51  Show Profile  Reply with Quote
RESTORE HEADERONLY will give you the details you want.
Go to Top of Page

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 09/01/2007 :  01:06:30  Show Profile  Reply with Quote
Hi,

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

Peter
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/01/2007 :  05:06:29  Show Profile  Reply with Quote
"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
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/01/2007 :  05:08:16  Show Profile  Reply with Quote
"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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000