Discuz!NT|BBS|论坛

注册

 

发新话题 回复该主题

数据库语句恢复 [复制链接]

1#
RESTORE DATABASE toppmskhapp
  
FROM DISK = 'd:\toppmskhapp.bak'
  
WITH MOVE 'toppmskhapp' TO 'D:\webs\khappsrv\database\toppmskhapp.mdf',
  
MOVE 'toppmskhapp_log' TO 'D:\webs\khappsrv\database\toppmskhapp_log.ldf',
  
STATS = 10, REPLACE
  
GO




RESTORE DATABASE toppmsapp
  
FROM DISK = 'd:\toppmsapp.bak'
  
WITH MOVE 'toppmsapp' TO 'D:\webs\mobileappsrv\database\toppmsapp.mdf',
  
MOVE 'toppmsapp_log' TO 'D:\webs\mobileappsrv\database\toppmsapp_log.ldf',
  
STATS = 10, REPLACE
  
GO






RESTORE DATABASE toppmswx2
  
FROM DISK = 'd:\toppmswx2.bak'
  
WITH MOVE 'toppmswx2' TO 'D:\webs\wxgzh\database\toppmswx2.mdf',
  
MOVE 'toppmswx2_log' TO 'D:\webs\wxgzh\database\toppmswx2_log.ldf',
  
STATS = 10, REPLACE
  
GO





RESTORE DATABASE dnt31
  
FROM DISK = 'd:\dnt31.bak'
  
WITH MOVE 'dnt31' TO 'D:\webs\helpbbs\database\dnt31.mdf',
  
MOVE 'dnt31_log' TO 'D:\webs\helpbbs\database\dnt31_log.ldf',
  
STATS = 10, REPLACE
  
GO





RESTORE DATABASE topsms
  
FROM DISK = 'd:\topsms.bak'
  
WITH MOVE 'topsms' TO 'D:\webs\topsms\database\topsms.mdf',
  
MOVE 'topsms_log' TO 'D:\webs\topsms\database\topsms_log.ldf',
  
STATS = 10, REPLACE
  
GO
分享 转发
TOP
发新话题 回复该主题