Yes, I am asking how to restore database automatically.

1. Actually I am taking backup of database using Database Maintenance Plans in a remote pc's disk.

2. The backup schedule runs two times at a day.

3. Now I want to schedule auto restore the latest backup file in the remote pc's sql server.

4. After that I want to auto delete the backup files of 1 week.

5. I am using SQL Server 2000 Enterprise Edition in both of the servers.

Please help me.