Do you mean the restore process is slow because you have to log on to every server and start restore manually?

There's no other way to run restore.

For backups, you can use the same script for all 100 SQL servers, to do full backup of all database on each server.

For restore, you can't use the same script on multiple SQL servers, because the restore script needs to point at the specific backup image created for the specific SQL server - in other words, one restore script per server.

BTW, I can't imagine all your 100 SQL servers all died at the same time and need recovery altogether at the same time ... is it some kind of development environment?

The news will be on TV if 100 of production SQL server database crash altogether, it must be a big organization.

Abe

[Quote]The news will be on TV if 100 of production SQL server database crash altogether, it must be a big organization.[/Quote] good joke :)
...is it some kind of development environment?
No, but sometimes scripts for update data on users datasases workwd incorrect. I understand - need quality testing, but it does not depend on me. I receive script after "good testing" :)