Restore large number of database on a server.

• sntiwary

  Hall of Fame

  Points: 3475

  More actions

  September 22, 2003 at 4:01 am

  #107195

  How to restore large number of databases on a server at a time? This is required in a situation where I need to restore around 300 databases from their backup files to a new server and I don't want to create and restore individually each and every DB instead of creating and restoring of all the databases at a time. So that I can reduce the recovery time.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  September 22, 2003 at 4:33 am

  #475224

  Duplicated post. Please see/post to http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16505&FORUM_ID=24&CAT_ID=1&Topic_Title=Restore+large+number+of+database+on+a+server%2E&Forum_Title=Backups