Restore database

Hi Guys,
I have question regarding restore database from dynamic database name. I
want to restore a database everyday automately in job from backup that has a
dynamic name(maintainance plan produced name). how can I get name automately.
Thanks.
Hello,
All the backup information and backup file names will be stored in a system
table backupset in MSDB database. You could use that information to
automatically restore
the database. Take a look into the below URL to get the file names.
http://www.sqlmag.com/Article/ArticleID/50183/sql_server_50183.html
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:76E8B869-82EF-46BF-AC1D-A61DEB95918C@.microsoft.com...
> Hi Guys,
> I have question regarding restore database from dynamic database name. I
> want to restore a database everyday automately in job from backup that has
> a
> dynamic name(maintainance plan produced name). how can I get name
> automately.
> Thanks.