← Tutti gli articoli

Restore a Filestream Database in SQL 2008

10 August 2010  ·  Sql Server 2008 · Article  ·  187 visite

Restore a Filestream Database in SQL 2008

  1. restore   database  MaragnaNet    
  2. from  disk =  'C:\backupdb\maragnanet.bak'   
  3. with   move   'MaragnaNet_Data'   to   'C:\Database\MaragnaNet_Data.mdf' ,   
  4. move   'AdventureWorks2008_Log'   to   'C:\Database\MaragnaNet_Log.ldf' ,   
  5. move   'FileStreamDocuments'   to   'C:\Database\MaragnaNetDocuments'   
or
 
 
RESTORE   
  1.   
  2. DATABASE [MaragnaNet]    
  3. FROM  
  4.   
  5. DISK = N'd:\BackupDb\MaragnaNet.bak'    
  6. WITH  
  7.   
  8. FILE = 1, MOVE N'Documenti'    
  9. TO  
  10.   
  11. N'C:\database\MaragnaNet_Files',    
  12.   
  13. NOUNLOAD, REPLACE, STATS = 10;   
or
  1. USE [master]  
  2. RESTORE DATABASE [MaragnaNet]   
  3. FROM  DISK = N'C:\temp\MaragnaNet.bak'  
  4.  WITH  FILE = 1,  MOVE N'MaragnaNet_Data' TO N'C:\database\MaragnaNet2012_Data.mdf',   
  5.   MOVE N'MaragnaNet_Log' TO N'C:\database\MaragnaNet2012_log.ldf',   
  6.    MOVE N'Documenti' TO N'C:\database\MaragnaNet2012_Files',   
  7.     NOUNLOAD,  REPLACE,  STATS = 5  
  8.   
  9. GO  

 
 
Si è verificato un errore imprevisto. Ricarica ✕

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.