Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup

Status
Not open for further replies.
sardinka2

sardinka2

Programmer
May 6, 2004
38
US
How can I check when database was restore from a backup and what backup was used?
 
Sort by date Sort by votes
I'm not sure you can find out which backup was used, but check out the SQL Server Error logs. They should list when backups and restores were done.

-SQLBill
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Olaf Doschke
  • Locked
  • Question
backup strategy
Replies
0
Views
191
Olaf Doschke
Olaf Doschke
EM1107
  • Locked
  • Question
Restore a database with a backup having a damage transaction log.
Replies
3
Views
232
gmmastros
gmmastros
millerwilliam35
  • Locked
  • Question
backup
Replies
1
Views
179
apogoreliy
apogoreliy
moorerichard49
  • Locked
  • Question
partial backup
Replies
2
Views
219
philhege
philhege
jonesrob797
  • Locked
  • Question
differential backup
Replies
1
Views
177
davismick643
davismick643

Part and Inventory Search

Sponsor

Back
Top