Cannot restore DB using T-SQL script

• jbeclapez

  SSC-Addicted

  Points: 405

  More actions

  September 22, 2020 at 12:33 pm

  #3790079

  I got it working doing something like that.

   

  RESTORE DATABASE OSTraining_98 --This is the destination name of the DB

  FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\RodierTrainingFood.bak'

  WITH MOVE 'OS_Trainer' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer.mdf',

  MOVE 'OS_Trainer_Default' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_Default.ndf',

  MOVE 'OS_Trainer_Timestamps' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_Timestamps.ndf',

  MOVE 'OS_Trainer_Audit' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_Audit.ndf',

  MOVE 'OS_Trainer_FileSystem' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_FileSystem.ndf',

  MOVE 'OS_Trainer_WorkflowActivity' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_WorkflowActivity.ndf',

  MOVE 'OS_Trainer_WorkflowHistory' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_WorkflowHistory.ndf',

  MOVE 'OS_Trainer_StageHistory' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_StageHistory.ndf',

  MOVE 'OS_Trainer_StageSource' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_StageSource.ndf',

  MOVE 'OS_Trainer_StageTarget' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_StageTarget.ndf',

  MOVE 'OS_Trainer_StageSummary' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_StageSummary.ndf',

  MOVE 'OS_Trainer_StageAttribute' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_StageAttribute.ndf',

  MOVE 'OS_Trainer_DataRecord' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_DataRecord.ndf',

  MOVE 'OS_Trainer_CalcStatus' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_CalcStatus.ndf',

  MOVE 'OS_Trainer_DataEntryAudit' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_DataEntryAudit.ndf',

  MOVE 'OS_Trainer_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\OSTraining_98_Trainer_log.ldf'