プロジェクト

全般

プロフィール

ダウンロード (256 Bytes)

restore.txt

SQL_Database_Restore - 蒲池 晃, 2019/03/20 06:03

 
1 
USE [master]
2 

    		
  

  

    
      3
    
    
      
RESTORE DATABASE [RESTORE????DB] FROM  


    		
  

  

    
      4
    
    
      
	DISK = N'D:\BackupFiles\xxxxxxx.bak' WITH  FILE = 1,


    		
  

  

    
      5
    
    
      
	MOVE N'????DB??'		TO N'D:\DATABASE\xxxxxx.mdf',  


    		
  

  

    
      6
    
    
      
	MOVE N'????DB??_log'	TO N'D:\DATABASE\xxxxxx.ldf',  


    		
  

  

    
      7
    
    
      
	NOUNLOAD,  REPLACE,  STATS = 5


    		
  

  

    
      8
    
    
      
GO