SQL Server 2012 latest multiple db restore script

• Lou

  SSCrazy

  Points: 2929

  More actions

  April 16, 2014 at 10:15 am

  #292457

  Hi,

  I'm testing a SQL server 2012 instance and I'm bringing a lot of SQL server 2005 databases, using backup/restore method, I have tested a few and it works without major problems till now.

  However, I want to restore a lot of them, what script or similar would help me ? I want to leave a script for future reference.

  Thanks a lot for your ideas

• pedro.v.cardoso

  SSC Enthusiast

  Points: 148

  More actions

  April 16, 2014 at 6:17 pm

  #1706626

  --Using a shared drive in a server

  --Initial Instance

  BACKUP DATABASE [Database1] TO DISK = N'\\share\Backups\Database1_20140417-0100.bak'

  WITH NOFORMAT, NOINIT, NAME = N'Database1s-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10;

  --Destination Instance

  RESTORE DATABASE [Database1]

  FROM DISK = N'\\share\Backups\Database1_20140417-0100.bak' WITH FILE = 1,

  MOVE N'Database1_Data' TO N'D:\DataFiles\Database1_Data.mdf',

  MOVE N'Database1_Log' TO N'E:\LogFiles\Database1_Log.ldf', NOUNLOAD, STATS = 10