ch12.sql

SQLServer2005基础教程,清华大学出版社

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


 



USE master
EXEC sp_addumpdevice 'disk', 
                     'testbackupfile', 
                     'C:\temp\testbackupfile.bak'


USE master
BACKUP DATABASE master TO DISK = 'C:\Temp\masterBackup.bak'



USE master
EXEC sp_addumpdevice 'disk', 'AdventureWorksBAC', 'C:\Temp\AWBAC.bak'
GO
BACKUP DATABASE AdventureWorks TO AdventureWorksBAC






USE master
GO
BACKUP DATABASE AdventureWorks TO DISK = 'C:\Temp\AWD1.bak' 
WITH DIFFERENTIAL



USE master
EXEC sp_addumpdevice 'disk', 'AdventureWorksLOGA001', 'C:\Temp\AWLOGA001.bak'
GO
BACKUP LOG AdventureWorks TO AdventureWorksBAC WITH NORECOVERY

USE master
RESTORE HEADERONLY FROM AdventureWorksLOGA001









BACKUP DATABASE AdventureWorks FROM AD_DBBACKUP 
USE master
RESTORE DATABASE AdventureWorks FROM AdventureWorksBAC '
WITH RECOVERY