案例.txt

主要介绍了sql的基础教程

数据库的备份与恢复案例
一、课堂演示案例
例一：在硬盘上创建备份设备
exec sp_addumpdevice 'disk',mybackupfile,
'c:\Mybackupfile.bak'
----------------------------------------------------------------------------------------------------------------------

例二：删除备份设备
exec sp_dropdevice mybackupfile
----------------------------------------------------------------------------------------------------------------------

例三：备份数据库数据到临时设备
backup database northwind
to disk = 'c:\northwind.bak'
----------------------------------------------------------------------------------------------------------------------

例四：完全备份数据库到备份设备
backup database northwind
to mybackupfile
----------------------------------------------------------------------------------------------------------------------

例五：执行差异备份
backup database northwind 
to mybackupfile
with differential 
----------------------------------------------------------------------------------------------------------------------

例六：备份日志文件到备份设备
exec sp_addumpdevice 'disk',mybackupLog,
'c:\MybackupLog.bak'

backup log northwind 
to mybackupLog
----------------------------------------------------------------------------------------------------------------------

例七：备份日志文件到临时备份设备
backup log northwind 
to disk = 'c:\mybackupLog.bak'
----------------------------------------------------------------------------------------------------------------------

例八：从备份设备还原数据库
restore database northwind
from mybackupfile
----------------------------------------------------------------------------------------------------------------------

例九：从备份文件还原数据库
backup database northwind
to disk = 'c:\northwindback.bak'

backup database northwind 
to disk = 'c:\northwindback.bak'
with differential 

restore database northwind
from disk = 'c:\northwindback.bak'
with file = 1,recovery

restore database northwind
from disk = 'c:\northwindback.bak'
with file = 2,recovery
----------------------------------------------------------------------------------------------------------------------

例十：事务日志还原
restore database northwind
from disk = 'c:\northwindback.bak'
with file = 1,norecovery

restore log northwind
from disk = 'c:\northwindLog.bak'
with file = 1,recovery
----------------------------------------------------------------------------------------------------------------------

例十一：时点还原
backup database northwind
to disk = 'c:\northwind.bak'

backup log northwind 
to disk = 'c:\mybackupLog.bak'

restore database northwind
from disk = 'c:\northwind.bak'
with file = 1,norecovery

restore log northwind
from disk = 'c:\mybackupLog.bak'
with file = 1 ,stopat = '2006-4-7 9:54:00' ,recovery