Backup and Restore
I have this situation with backup and restore.
I have two instances of sql, sql1 and sql2.
Production server is sql1 and test server is sql2.
I created database maintenance plan that makes full backup every night on tape.
I would like to make some kind of job or to add steps to job that was created with DMplan which will make restore of backuped database to sql2 server.
How can i do this? How can i read which is the last file backuped on tape?
Thanks very much