ch06 backuprestore.sql

SQL+Server实用简明教程电子教案和实例源文件

sp_addumpdevice 'device_type', 'logical_name', 'physical_name'


 

 


USE master
EXEC sp_addumpdevice 'DISK', 
                     'testbackupfile', 
                     'D:\SQLServerDBData\testbackupfile.bak'
GO





USE master
BACKUP DATABASE master 
  TO DISK = 'D:\SQLServerDBData\masterBackup_1215.bak'
GO






USE master
EXEC sp_addumpdevice 'DISK',
                     'AdventureWorksBAC', 
                     'D:\SQLServerDBData\AWBAC.bak'
GO
BACKUP DATABASE AdventureWorks TO AdventureWorksBAC












USE master
BACKUP DATABASE AdventureWorks 
  TO DISK = 'D:\SQLServerDBData\AWD_1.bak' 
  WITH DIFFERENTIAL
GO




USE master
EXEC sp_addumpdevice 'DISK', 
                     'AdventureWorksLOGA001', 
                     'D:\SQLServerDBData\AWLOGA001.bak'
GO
BACKUP LOG AdventureWorks TO AdventureWorksLOGA001 
  WITH NORECOVERY





USE master
RESTORE HEADERONLY FROM AdventureWorksBAC
GO











BACKUP DATABASE AdventureWorks FROM AD_DBBACKUP 

USE master
RESTORE DATABASE AdventureWorks FROM AdventureWorksBAC
  WITH RECOVERY
GO