数据库备份的校验

最新推荐文章于 2024-08-04 20:42:53 发布

SarahCla

最新推荐文章于 2024-08-04 20:42:53 发布

阅读量1.2k

点赞数

分类专栏：数据库文章标签：数据库 sql server database file disk

本文链接：https://blog.csdn.net/sarahcla/article/details/7219439

版权

数据库专栏收录该内容

34 篇文章 0 订阅

订阅专栏

 
  USE MASTER 
 
  -- Add a new backup device 
 
  -- Ensure that the SQL Server can read from the physical location where the backup is placed 
 
  --                    TYPE      NAME           PHYSICAL LOCATION 
 
  EXEC 
   SP_ADDUMPDEVICE  
  'disk' 
  , 
  'networkdrive' 
  , 
  '\\VPCW2K8\Database Backup\Test.bak' 
 
  -- Execute the Restore operation in VERIFY ONLY mode 
 
  -- Provide the actual paths where you plan to restore the database. 
 
  -- This is because VERIFYONLY also checks for available space 
 
  RESTORE 
 
  VERIFYONLY 
 
  FROM  
   networkdrive 
 
  WITH 
 
  MOVE 
   N 
  'TESTDB_DATA'    
   TO 
  N 
  'E:\TestDB\TestDB_Data.mdf' 
  ,   
 
  MOVE 
   N 
  'TESTDB_INDEXES' 
   TO 
  N 
  'E:\TestDB\TestDB_Idx.mdf' 
  ,   
 
  MOVE 
   N 
  'TESTDB_LOG'     
   TO 
  N 
  'E:\TestDB\TestDB_LOG.ldf' 
 
  -- DROP THE DEVICE 
 
  --                   Name         , Physical File (OPTIONAL - if present, the file is deleted) 
 
  EXEC 
   SP_DROPDEVICE  
  'networkdrive'