Sorry if this question seems redundant (I've seen several other posts addressing this same subject) But here goes... I have about 30 Databases on a Production SQL Server STANDARD Edition 2000k Instance. All Backups are performed using SQL Server Maintenance plans (Full Nightly backups and periodic Xaction log backups during business hours) I would like the ability to copy the FULL Backups to another Server - perhaps on a nightly basis - and then restore them to this other Server as a means of having some sort of Disaster Recovery. I know with Enterprise Edition, you can set up linked servers and do log shipping or replication, but I don't have that luxury here. I also don't have access to the MS Backoffice Resourvce Kit - which I understand has some canned scripts to do what I want to do here. My problem really is that because I don't have control over the backup filenames, how to I automate the restore process on the second Server? any help would be much appreciated.