restore database 

RESTORE DATABASE CTSDW
FROM DISK = '\\detego-ctsetl\Backup\CTSDW\CTSDW_backup_20160722110003_Full.bak'
WITH MOVE 'CTSDW' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW.mdf'
       ,MOVE 'CTSDW_1' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_1.ndf'
       ,MOVE 'CTSDW_2' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_2.ndf'
       ,MOVE 'CTSDW_3' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_3.ndf'
       ,MOVE 'CTSDW_4' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_4.ndf'
       ,MOVE 'CTSDW_5' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_5.ndf'
       ,MOVE 'CTSDW_6' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_6.ndf'
       ,MOVE 'CTSDW_7' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_7.ndf'
       ,MOVE 'CTSDW_8' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_8.ndf'
       ,MOVE 'CTSDW_9' TO 'H:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_9.ndf'
       ,MOVE 'CTSDW_10' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_10.ndf'
       ,MOVE 'CTSDW_11' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_11.ndf'
       ,MOVE 'CTSDW_12' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_12.ndf'
       ,MOVE 'CTSDW_13' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_13.ndf'
       ,MOVE 'CTSDW_14' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_14.ndf'
       ,MOVE 'CTSDW_15' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_15.ndf'
       ,MOVE 'CTSDW_16' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_16.ndf'
       ,MOVE 'CTSDW_17' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_17.ndf'
       ,MOVE 'CTSDW_18' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_18.ndf'
       ,MOVE 'CTSDW_19' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_19.ndf'
       ,MOVE 'CTSDW_20' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_20.ndf'
       ,MOVE 'CTSDW_21' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_21.ndf'
       ,MOVE 'CTSDW_22' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_22.ndf'
       ,MOVE 'CTSDW_23' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_23.ndf'
       ,MOVE 'CTSDW_24' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_24.ndf'
       ,MOVE 'CTSDW_25' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_25.ndf'
       ,MOVE 'CTSDW_26' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_26.ndf'
       ,MOVE 'CTSDW_27' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_27.ndf'
       ,MOVE 'CTSDW_28' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_28.ndf'
       ,MOVE 'CTSDW_29' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_29.ndf'
       ,MOVE 'CTSDW_30' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_30.ndf'
       ,MOVE 'CTSDW_31' TO 'I:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_31.ndf'
       ,MOVE 'CTSDW_32' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_32.ndf'
       ,MOVE 'CTSDW_33' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_33.ndf'
       ,MOVE 'CTSDW_34' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_34.ndf'
       ,MOVE 'CTSDW_35' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_35.ndf'
       ,MOVE 'CTSDW_36' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_36.ndf'
       ,MOVE 'CTSDW_37' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_37.ndf'
       ,MOVE 'CTSDW_38' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_38.ndf'
       ,MOVE 'CTSDW_39' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_39.ndf'
       ,MOVE 'CTSDW_40' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_40.ndf'
       ,MOVE 'CTSDW_log' TO 'O:\MSSQL12.MSSQLSERVER\MSSQL\DATA\CTSDW_log.ldf'
       ,NOUNLOAD
       ,REPLACE
       ,STATS = 10

 

posted @ 2016-07-26 10:49  ethan_song  阅读(464)  评论(0)  编辑  收藏  举报