I know it sounds like a bad title but here is what I want to do:

I have backups running of various SQL Server (actually LiteSpeed backups but not important for this point). The backups are named DBName_date_time.bak and stored on a server.

I want to find the lastest backup of the database (full each night) and apply that to another server (a reporting and test server). I understand how to call the LiteSpeed restore xp_ proc and what goes inside it.

How do I get the latest file for each database using T-SQL.

Gary