Can you schedule multiple database restores for the same day and time?

danny425

I have about 40 restores that I am going to schedule from one database server. I currently have all of the databases back up each night at 7:00 PM. The question I have is, can I have each restore job be scheduled for the same day/time (Say every Sunday at noon)? Will it work similarly to the backup process? Or would I have to do them at different times?

petey2

You would need to stagger them.  The SQL Backup engine is a 32-bit application, and it can only access up to 1.4 GB of memory realistically.  Running 40 restores simultaneously will easily use up the memory it can access.  There is then also the CPU and storage device limitations keeping up with 40 simultaneous restores.

petey2

There isn't an option in SQL Backup to restore a series of databases automatically, unlike backups.  Each restore process will only restore a single database.

danny425

I am going in and scheduling them one at a time. What I'm asking is if I schedule them each to restore at noon on Sunday, if all restores will be successful or would I need to stagger the times I schedule them for.