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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find a backup file with timestqamp name in its name

Status
Not open for further replies.
TruthAndBeauty

TruthAndBeauty

Technical User
Jun 4, 2001
38
US
My SQL database ("Site1db") is backed up to disk and automatically given a name that includes a timestamp (i.e., Site1db200201222130.bak"). I want to use the latest backup file forsite1db to restore a similar db ('Site2db") at a different location.
To setup a job to restore "Site2db" I need to be able to identify the latest Site1db backup file as the source file for the backup.

I'm investigating the system tables for a solution. Perhaps there are Command codes. Any suggestions are appreciated????

Thanks for taking the time.

Robert



 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
1K
gmmastros
gmmastros
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
948
SashaBuilder3
SashaBuilder3
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
668
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
760
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top