Hi there,

Backing them up isn't a hassle. Create a backup job/policy and select the databases before putting them on a schedule.

Automatically restoring them is another story, and this can't be done with BE at all. Certainly not BE 2010 and earlier versions. You will have to manually run the restore yourself.

You can try going to the Ideas section below & adding it in, but I don't know what the chances of it being implemented will be.

https://www-secure.symantec.com/connect/backup-and-recovery/ideas

Thanks!

You won't be able to schedule the restores as CraigV said.

But if you are using SQL 2005 SP1 or higher, you can use Database Mirroring to do this.

http://msdn.microsoft.com/en-US/library/cc917680

Any reason you can't just schedule a SQL-to-SQL copy?

I Don't know how can do that,

I have a physical server with about 70 databases, I want copy only 4 of them to a virtual machine every day but i don't know how can i do this.

Do you have any suggestion?