restore database

RESTORE DATABASE CTSDW
FROM DISK = '\detego-ctsetlBackupCTSDWCTSDW_backup_20160722110003_Full.bak'
WITH MOVE 'CTSDW' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW.mdf'
       ,MOVE 'CTSDW_1' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_1.ndf'
       ,MOVE 'CTSDW_2' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_2.ndf'
       ,MOVE 'CTSDW_3' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_3.ndf'
       ,MOVE 'CTSDW_4' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_4.ndf'
       ,MOVE 'CTSDW_5' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_5.ndf'
       ,MOVE 'CTSDW_6' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_6.ndf'
       ,MOVE 'CTSDW_7' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_7.ndf'
       ,MOVE 'CTSDW_8' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_8.ndf'
       ,MOVE 'CTSDW_9' TO 'H:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_9.ndf'
       ,MOVE 'CTSDW_10' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_10.ndf'
       ,MOVE 'CTSDW_11' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_11.ndf'
       ,MOVE 'CTSDW_12' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_12.ndf'
       ,MOVE 'CTSDW_13' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_13.ndf'
       ,MOVE 'CTSDW_14' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_14.ndf'
       ,MOVE 'CTSDW_15' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_15.ndf'
       ,MOVE 'CTSDW_16' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_16.ndf'
       ,MOVE 'CTSDW_17' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_17.ndf'
       ,MOVE 'CTSDW_18' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_18.ndf'
       ,MOVE 'CTSDW_19' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_19.ndf'
       ,MOVE 'CTSDW_20' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_20.ndf'
       ,MOVE 'CTSDW_21' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_21.ndf'
       ,MOVE 'CTSDW_22' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_22.ndf'
       ,MOVE 'CTSDW_23' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_23.ndf'
       ,MOVE 'CTSDW_24' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_24.ndf'
       ,MOVE 'CTSDW_25' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_25.ndf'
       ,MOVE 'CTSDW_26' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_26.ndf'
       ,MOVE 'CTSDW_27' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_27.ndf'
       ,MOVE 'CTSDW_28' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_28.ndf'
       ,MOVE 'CTSDW_29' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_29.ndf'
       ,MOVE 'CTSDW_30' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_30.ndf'
       ,MOVE 'CTSDW_31' TO 'I:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_31.ndf'
       ,MOVE 'CTSDW_32' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_32.ndf'
       ,MOVE 'CTSDW_33' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_33.ndf'
       ,MOVE 'CTSDW_34' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_34.ndf'
       ,MOVE 'CTSDW_35' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_35.ndf'
       ,MOVE 'CTSDW_36' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_36.ndf'
       ,MOVE 'CTSDW_37' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_37.ndf'
       ,MOVE 'CTSDW_38' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_38.ndf'
       ,MOVE 'CTSDW_39' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_39.ndf'
       ,MOVE 'CTSDW_40' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_40.ndf'
       ,MOVE 'CTSDW_log' TO 'O:MSSQL12.MSSQLSERVERMSSQLDATACTSDW_log.ldf'
       ,NOUNLOAD
       ,REPLACE
       ,STATS = 10
原文地址:https://www.cnblogs.com/ethan-song/p/5706622.html